请问:一次插入多条数据问题!对表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);如何用一条语句插入语句
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);如何用一条语句插入语句
Select 1,'aa',10 from dual union all
Select 1,'bb',10 from dual union all
Select 1,'cc',10 from dual