Multi Table Insert

문법

INSERT [ALL/FIRST]
        WHEN 조건1 THEN
            INTO 테이블1
        WHEN 조건2 THEN
            INTO 테이블2
        ELSE
      INTO 테이블0
      SELECT 구문;

예제

INSERT ALL
   WHEN TO_CHAR (order_date, 'YYYY') = '1990'
   THEN
      INTO order_1990
   WHEN TO_CHAR (order_date, 'YYYY') = '1991'
   THEN
      INTO order_1991
   WHEN TO_CHAR (order_date, 'YYYY') = '1992'
   THEN
      INTO order_1992
   SELECT order_id, order_date, customer_id, order_total, sales_rep_id
     FROM orders;