오라클 9i 부터 제공되는 multi-table insert 방법

방법 1)

insert all
    into job_yr_sal values (job, cnt, tot_sal)
    into job_av_com values (job, cnt, avg_com)
select    job, count(*), k sum(sal) tot_sal, avg(comm) avg_com
from    emp, dept
where    emp.deptno = dept.deptno
group by job;

방법 2)

insert all
    when deptno in (select deptno from dept) then
            into regular_emp values (empno, ename, deptno)
    when job in ('CLERK', 'SAQLESMAN') then
            into sale_emp values (empno, ename, job)
select    empno, ename, job, deptno
from     emp;

방법 3)

insert first
    when sal>10000 then into special_empno values (empno, sal)
    when sal>5000  then into normal_empno values (empno, sal)
    when sal>3000  then into normal_empno values (empno, sal)
    else into low_empno values (empno, sal)
select    empno, sal
from     emp;