Insert into table_name
select 值1,值2,.. from dual
union all
select 值1,值2,.. from dual
例:
在建好的SC表里插入记录如下:
01,语文,90;
01,英语,70;
insert into sc
Select '01','语文',90 from dual
Union all
Select '01','英语',70 from dual
Insert into table_name
select 值1,值2,.. from dual
union all
select 值1,值2,.. from dual
例:
在建好的SC表里插入记录如下:
01,语文,90;
01,英语,70;
insert into sc
Select '01','语文',90 from dual
Union all
Select '01','英语',70 from dual