오라클 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 … Continue reading →