可以用以下格式
insert into tablename(column1,column2)
select 1,'aaa' from dual union all
select 2,'bbb' from dual union all
select 3,'ccc' from dual;
可以用以下格式
insert into tablename(column1,column2)
select 1,'aaa' from dual union all
select 2,'bbb' from dual union all
select 3,'ccc' from dual;