create table t1(a int,b int);
/
create table t2(a int,b int);
/
create table t3(a int,b int);
/
insert into t2 values(1,1);
/
insert into t2 values(2,2);
/
insert into t3 values(3,3);
/
insert into t3 values(4,4);
/

insert into t1(a,b)
values(
             (select a from t2 where rownum=1),
             (select b from t3 where rownum=1)
            );


小记：１，values内的子查询只能适用于返回单行单行值
             2,   values内的子查询的select列只是单个列，而不能是多行