orclz> create table d1 as select * from dept where 1=2;

Table created.

orclz> create table d2 as select * from dept where 1=2;

Table created.


orclz> create sequence s1;

Sequence created.

orclz> insert all into d1 values(s1.nextval,dname,loc) into d2 values(s1.nextval,dname,loc)
  2  select dname,loc from dept;

8 rows created.

orclz> select * from d1;

    DEPTNO DNAME          LOC
---------- -------------- -------------
         1 ACCOUNTING     NEW YORK
         2 RESEARCH       DALLAS
         3 SALES          CHICAGO
         4 OPERATIONS     BOSTON

orclz> select * from d2;

    DEPTNO DNAME          LOC
---------- -------------- -------------
         1 ACCOUNTING     NEW YORK
         2 RESEARCH       DALLAS
         3 SALES          CHICAGO
         4 OPERATIONS     BOSTON

orclz>