高级dml操作

将一张表的数据分别插入到多张表中

建立实验表e1,e2

drop table e1 purge;

drop table e2 purge;

create table e1 as select ename,sal,hiredate

from emp where 9=0;

create table e2 as select ename,deptno,mgr

from emp where 9=0;

insert all

into e1 values(ename,sal,hiredate)

into e2 values(ename,deptno,mgr)

select ename,sal,hiredate,deptno,mgr

from emp where deptno=10;

select * from e1;

select * from e2;

All的含义为：emp表中的一行将插入到e1,e2中

insert first

when sal>3000 then

into e1 values(ename,sal,hiredate)

when sal>2000 then

into e2 values(ename,deptno,mgr)

select ename,sal,hiredate,deptno,mgr

from emp ;

First的含义为：一行只能给一张表，即使两个表的条件都符合