使用直接装载
INSERT /*+APPEND */ INTO table1 SELECT * FROM table2
INSERT INTO table1 VALUES(12,2,DEFAULT);
多表插入,ALL,FIRST
ALL 每个子句都执行子查询
INSERT ALL
WHEN aa=1 THEN INTO table1
WHEN aa=2 THEN INTO table2
WHEN aa=3 THEN INTO table3
ELSE INTO other_table
SELECT * FROM table
FIRST 如果数据被插入过,那么这行数据不会被再使用
INSERT FIRST
WHEN aa=1 THEN INTO table1
WHEN aa=2 THEN INTO table2
WHEN aa=3 THEN INTO table3
ELSE INTO other_table
SELECT * FROM table