请问:一次插入多条数据问题!
请问:一次插入多条数据问题!

对表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