发布时间：2014-07-11 17:18:15

一、创建测试表 SQL> create table  testcursor as select 3333 as id, t.* from dba_objects t; Table created 二、创建索引SQL> create index idx_testcursor on testcursor(id); Index created 三、查看当前参数 SQL> show parameter cursor_sharing; NAME   &.........【阅读全文】

发布时间：2014-07-08 11:45:44

一、创建测试表SQL> Create Table Testsample As Select Object_Id, Object_Name From Dba_Objects Where 1=2; Table created 二、创建索引SQL> Create Index i_Idx_Testsample On Testsample(Object_Id); Index created 三、插入数据SQL>  Insert Into Testsample Select Object_Id, Ob.........【阅读全文】

发布时间：2014-07-07 14:41:25

一、创建测试表SQL> create table t_obj as select * from dba_objects; Table created二、创建索引SQL> create index t_obj_ind on t_obj(object_id); Index created 三、收集统计信息SQL> exec dbms_stats.gather_table_stats(user,'t_obj',cascade=>true); PL/SQL procedure successfull.........【阅读全文】

发布时间：2014-07-07 10:59:21

一、执行多次查询：SQL> beginfor i in 1..100 loopexecute immediate 'select * from emp where empno=' || i;end loop;end;/二、创建测试表SQL> create table test as select sql_text from v$sqlarea; Table created三、添加字段SQL> alter table test add constraintname varchar2(1000); Tab.........【阅读全文】

发布时间：2014-07-04 10:51:58

一、创建测试表SQL> Create Table T  As Select * From Dba_Objects; Table created二、创建索引SQL> Create Index t_Ind On t (Object_Id); Index created三、收集统计信息 SQL> exec dbms_stats.gather_table_stats(user,'T',cascade=>true); PL/SQL procedure successfully complet.........【阅读全文】