oracle Insert 一次插入多条记录

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