重庆思庄Oracle、、PostgreSQL、Redhat认证学习论坛

标题: 迪卡集例子 [打印本页]

作者: 郑全 时间: 2013-5-18 11:24
标题: 迪卡集例子

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

欢迎光临重庆思庄Oracle、、PostgreSQL、Redhat认证学习论坛 (http://bbs.cqsztech.com/)