迪卡集例子

郑全

 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编辑过]