CREATE TABLE bigtab AS SELECT rownum as "id", a.* FROM all_objects a;
create table smalltab as select rownum as "id", a.* FROM all_tables a;
ALTER TABLE bigtab MODIFY (empno NUMBER);
DECLARE n NUMBER; BEGIN FOR n IN 1..100 LOOP INSERT INTO bigtab SELECT rownum as "id", a.* FROM all_objects a; COMMIT; END LOOP; END;
DECLARE v_var number; BEGIN FOR n IN 1..6 LOOP select count(*) into v_var from bigtab b, smalltab a; END LOOP; END;
[此贴子已经被作者于2013-5-18 11:24:39编辑过] |