oracle Insert 一次插入多条记录有两种方法：
1）Insert All Into table_name values ...
insert all into table_name values(‘111‘,‘122‘) into table_name values(‘222‘,‘222‘) select 1 from dual;
2）Insert Into table_name select from
insert into table1_name select t1.column_name,‘111‘ from table2_name t1 where t1.column=‘1‘
原文：https://www.cnblogs.com/wulishun111/p/9310267.html