-
编辑 删除
oracle中的单行函数
OCP-007-Chapter3 单行函数中有提到oracle中的单行函数目的完成这一章，可以作下列事情：描述SQL中可用的不同函数类型在select语句中使用字符、数字和日期函数描述转换函数的应用函数是SQL非常有用的特性，可以实现...
-
编辑 删除
nvl, nvl2, nullif
NVL,NVL2,NULLIF三个函数的含义NULL指的是空值，或者非法值。 NVL (expr1, expr2)->expr1为NULL，返回expr2；不为NULL，返回expr1。注意两者的类型要一致 NVL2 (expr1, expr2, expr3) ->expr1不为NULL，返回expr2；...
-
编辑 删除
RTFM("Read The Fucking Manual")的意思(zt)
今天在oracle-l看到一个贴子-------------------quote begin------------------------------日期:Mon, 5 Feb 2007 09:07:37 +0530发件人:"Anand Rao" <panandrao@gmail.com> 收件人:"Oracle-l...
-
编辑 删除
pipe-out-from-a-sequence-of-commands to sqlplus
C:\Documents and Settings\xxx>(More? echo select sysdate from dualMore? echo /More? echo exitMore? )|sqlplus c2c/c2c@c2cSQL*Plus: Release 10.2.0.1.0 - Production on 星期一 2月 5 15:02:51 2007Copyrig...
-
编辑 删除
关于legacy system中使用bind variables(zt)
http://preferisco.blogspot.com/2006/04/how-many-binds-does-it-take-to-save.htmlSunday, April 02, 2006How many binds does it take to save time? Here's a tale about how something that seems intuit...
-
编辑 删除
expdp report error when export tables
;;;Export: Release 10.2.0.1.0 - 64bit Production on Friday, 09 February, 2007 11:02:01Copyright (c) 2003, 2005, Oracle. All rights reserved.;;;Connected to: Oracle Database 10g Enterprise Editi...
-
编辑 删除
How Can I unload data to a flat file
http://www.evdbt.com/unload.sqlhttp://www.jaredstill.com/content/dump.htmlhttp://asktom.oracle.com/tkyte/flat/index.htmlhttp://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:728625409049...
-
编辑 删除
shared_pool_lru_stats
http://www.freelists.org/archives/oracle-l/11-2004/msg00291.htmlhttp://www.freelists.org/archives/oracle-l/04-2006/msg01150.html
-
编辑 删除
Oracle, History and the Wait Interface
http://www.dbazine.com/olc/olc-articles/still3
-
编辑 删除
Pipelined Functions
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:19481671347143
-
编辑 删除
oracle10.2.0.1.0中与all_objects有关的bug
IIRC this is a known bug. Just go back to 9i view definition or changethe all_objects view definition with /*+RULE */ hint.K GopalakrishnanCo-Author: Oracle Wait Interface, Oracle Press 2004http://www...
-
编辑 删除
在sqlplus交互环境下测试存储过程
sqlplus手册中说得比较清楚Use the following commands to create and display bind variables.PRI[NT] [variable ...]Displays the current values of bind variables, or lists all bind variables.VAR[IABLE] [va...
-
编辑 删除
找出B中没有包括A中对像的同义词的A对像
column object_name format a30select a.owner, a.object_name, a.object_type from dba_objects a where a.owner = '&BASE_OBJECT_SCHEMA' -- choose ...
-
编辑 删除
library cache pin 中block情况
library cache pin在compile 对像(比如procedure,function,package,triiger等)时发生得较多.通过下面的脚本可以观察lock情况.select decode(lob.kglobtyp, 0, 'NEXT OBJECT', 1, 'INDEX', 2, 'TABLE', 3, 'CLUSTER',...
-
编辑 删除
dml locks(dml_locks)
Parameter type IntegerDefault value Derived: 4 * TRANSACTIONSModifiable NoRange of values 20 to unlimited; a setting of 0 disables enqueuesBasic NoReal ApplicationClustersYou must set this parameter f...
-
编辑 删除
dbms_xplan
测试表：create table tb1 as select dba_objects;SQL>delete from plan_table;SQL>explain plan for select owner,object_type,count(*) from tb1 group by owner,object_type;SQL> select * from table( dbms_xpla...
-
编辑 删除
datafile on nfs mount
Q:Per note 359515.1 nfs mounts are supported for datafiles with oracle 10. Does anyone know if the same applies for 9.2 databases? I urgently need to create a clone of a 9.2 environment, but suprise s...
-
编辑 删除
备份文件的管理(rman,find,gzip etc.)
My Unix Rman scrīpt runs Rman that puts the backups in a certaindirectory. I use the find command to compress all files that have notalready been compressed. (find $BACKUP_DIR/* \! -name '*.gz'...
