INSERT ALL 샘플

INSERT ALL 사용하기

RECORD로 조회된 데이터를 반복해서 INSERT하기 샘플입니다.

 

insert all
  into worked_hours (weekno, empno,day, hours)
  values (weekno, empno, 1, mon)
  into worked_hours values (weekno,empno, 2, tue)
  into worked_hours values (weekno,empno, 3, wed)
  into worked_hours values (weekno,empno, 4, thu)
  into worked_hours values (weekno,empno, 5, fri)
  into worked_hours values (weekno,empno, 6, sat)
  into worked_hours values (weekno,empno, 7, sun)
select weekno
,      empno
,      mon, tue, wed, thu, fri, sat, sun
from   employee_week_records;

 

출처 : http://technology.amis.nl/2004/12/16/pivoting-in-sql-using-the-10g-model-clause/