详解Oracle中一条insert语句同时插入多张表

1.Oralce官方文档参考链接

http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_9014.htm#SQLRF01604

2、创建源表STUINFO，并插入几条测试数据

create table stuInfo(
             id number,
             name varchar2(60),
             sex varchar2(10),
             age number(3));

insert into stuInfo values(1001,'KevinMa','F',28);
insert into stuInfo values(1002,'Merry','M',18);
insert into stuInfo values(1003,'Ketty','M',16);
insert into stuInfo values(1004,'King','F',28);
commit;

3、创建目标表aa，bb

create table aa as select * from stuInfo where 1=0;
create table bb as select * from stuInfo where 1=0;