ITPub博客

oracle hint_index_ffs,index_joinindex_ffs hint1,对表用快速索引全扫描进行访问2,经测,仅count可以使用index_ffs,而非count聚合函数好像不能使用index_ffsSQL> explain plan for select /*+ index_ffs(t_t...

oracle hint之full,index,index_asc,index_desc,index_combile示例1,full hintSQL> explain plan for select a,b from t_test where a=3;已解释。SQL> select * from table(dbms_xplan.display);PLAN_TABLE_...

session1>desc t_global_temp; 名称                         &nbs...

create or replace procedure sp_t_date(in_start_date date,in_table_count pls_integer)isv_sql varchar2(4000);v_receive char(8);begin  v_receive:=to_char(in_start_date,'yyyymmdd');  for...

http://blog.chinaunix.net/uid-24612962-id-3161892.html

oracle hint no_merge强制oracle不把子查询inline view和outer view外层查询合并为一个单一的查询,即子查询运行出结果集再和外层查询的其它结果集进行关联操作 下为测试结果  SQL> explain p...

http://www.hellodba.com/reader.php?ID=86&lang=CN

http://www.hellodba.com/reader.php?ID=178&lang=CN http://www.hellodba.com/reader.php?ID=179&lang=CN

SQL> show userUSER 为 "SCOTT"SQL> create table t_tonyi(a int);表已创建。SQL> create public synonym t_tongyi for scott.ton...

create or replace procedure proc_auto_commentasv_number pls_integer;v_repl_string varchar2(100);v_sql varchar2(4000);v_sqlerrm varchar2(1000);begin v_number:=2; for i in 1..v_number ...

http://www.ssc.stn.sh.cn/html/zsk/ITyw/2012-04/5819.html

http://www.ssc.stn.sh.cn/html/zsk/ITyw/2012-04/5819.html

--16进制转10进制,用to_number,里面的参数是16进制的数据,且参数用单引号括起SQL> select to_number('ff','xx') from dual; TO_NUMBER('FF','XX')--------------------     &...

 --查询某个sql对应事务产生的undo数据块select sid, action, module  from v$session where type = 'USER'   AND SCHEMANAME = 'SYS';select vt.used_ublk  from v$transact...

http://space.itpub.net/35489/viewspace-683646

http://space.itpub.net/8984272/viewspace-619964

create or replace procedure proc_bulk_table(x  char(1))as  v_number pls_integer;  v_cnt pls_integer;  v_begin pls_integer;  v_receive char(1);  begin  &...

调试存储过程时,发现产品表中许多列的值可能为null,导致not exists产生结果与所期不符测试如下--构建两个同样表结构的表SQL> desc t_null_column;         &n...

oracle hint1,hint类型   1,适用于单表，如:index和use_nl   2,用于多表,如：leading,use_nl(table1 table2)其实是use_nl(table1)和use_nl(table2)的缩写   3,用于查询块：如...

SQL> select * from t_source;                           &n...