[Oracle / 오라클] INSERT ALL, WHEN으로 조건별 다중 테이블에 일괄 INSERT 시키기

입력할 기준 테이블 조회 

SELECT * FROM tb_point order by point;

CUSTOMER_CD 기준 2017 ~ 2019개의 27개 로우

년도별 분리할 테이블 생성 

TB_POINT_2017;
TB_POINT_2018;
TB_POINT_2019;

 

 

INSERT ALL
	WHEN SUBSTR(REG_DTTM, 1, 4) = '2017' THEN INTO TB_POINT_2017
	WHEN SUBSTR(REG_DTTM, 1, 4) = '2018' THEN INTO TB_POINT_2018
	WHEN SUBSTR(REG_DTTM, 1, 4) = '2019' THEN INTO TB_POINT_2019
	ELSE INTO TB_POINT_2019
SELECT CUSTOMER_CD, SEQ_NO, POINT_MEMO, POINT, REG_DTTM FROM TB_POINT
WHERE REG_DTTM >= '20170101000000';