请问:一次插入多条数据问题!
对表test
create table (
id number,
name varchar(10),
age number
)
执行
insert into test values(1, 'aa ',10);
insert into test values(1, 'bb ',10);
insert into test values(1, 'cc ',10);
如何用一条语句插入语句
------解决方案--------------------
insert into test
Select 1, 'aa ',10 from dual union all
Select 1, 'bb ',10 from dual union all
Select 1, 'cc ',10 from dual