오라클 특수구문 - INSERT ALL

INSERT ALL
INTO AS_HIST VALUES (CUST_NO, REG_DT, STAT_CD)
INTO CSLT_HIST VALUES (CUST_NO, REG_DT, CALL_CONT)

(SELECT 'B100' CUST_NO
    , TO_CHAR(SYSDATE, 'YYYYMMDD') REG_DT
    , '완료' STAT_CD
    , 'TV고장' CALL_CONT
    FROM DUAL)

 테이블의 컬럼이름을 대상으로 INSERT가 실행 

INSERT ALL
WHEN SALE_MON IS NOT NULL THEN INTO SALES_DATA VALUES (NAME, 1, SALE_MON)
WHEN SALE_TUE IS NOT NULL THEN INTO SALES_DATA VALUES (NAME, 2, SALE_TUE)
WHEN SALE_WED IS NOT NULL THEN INTO SALES_DATA VALUES (NAME, 3, SALE_WED)
WHEN SALE_THUR IS NOT NULL THEN INTO SALES_DATA VALUES (NAME, 4, SALE_THUR)
WHEN SALE_FRI IS NOT NULL THEN INTO SALES_DATA VALUES (NAME, 5, SALE_FRI)
WHEN SALE_SAT IS NOT NULL THEN INTO SALES_DATA VALUES (NAME, 6, SALE_SAT)
(SELECT NAME, SALE_MON, SALE_TUE, SALE_WED, SALE_THUR, SALE_FRI, SALE_SAT FROM LD_DATA)

WHEN THEN 은 NULL일때 피하는 구문