<\/p>\n
\uc624\ub77c\ud074 9i \ubd80\ud130 \uc81c\uacf5\ub418\ub294 multi-table insert \ubc29\ubc95<\/p>\n
\ubc29\ubc95 1)<\/p>\n
insert all\r\n into job_yr_sal values (job, cnt, tot_sal)\r\n into job_av_com values (job, cnt, avg_com)\r\nselect job, count(*), k sum(sal) tot_sal, avg(comm) avg_com\r\nfrom emp, dept\r\nwhere emp.deptno = dept.deptno\r\ngroup by job;<\/pre>\n\ubc29\ubc95 2)<\/p>\n
insert all\r\n when deptno in (select deptno from dept) then\r\n into regular_emp values (empno, ename, deptno)\r\n when job in ('CLERK', 'SAQLESMAN') then\r\n into sale_emp values (empno, ename, job)\r\nselect empno, ename, job, deptno\r\nfrom emp;<\/pre>\n\ubc29\ubc95 3)<\/p>\n
insert first\r\n when sal>10000 then into special_empno values (empno, sal)\r\n when sal>5000 then into normal_empno values (empno, sal)\r\n when sal>3000 then into normal_empno values (empno, sal)\r\n else into low_empno values (empno, sal)\r\nselect empno, sal\r\nfrom emp;<\/pre>\n<\/p>\n","protected":false},"excerpt":{"rendered":"
\uc624\ub77c\ud074 9i \ubd80\ud130 \uc81c\uacf5\ub418\ub294 multi-table insert \ubc29\ubc95 \ubc29\ubc95 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 … Continue reading