oracle 同时向多个表写数据

insert all

when deptno=10 then into dept10

when deptno=20 then into dept20

else into other

select * from emp;

//当数据已经满足先前条件，并且已经被插入到其表，那么该行数据在后续的插入中将不会被利用

insert first

when deptno=10 then into dept10

when deptno=20 then into dept20

when job='CLERK' then into clerk

else into other

select * from emp;