一楼正解, 貌似你可以使用insert all when 完成。 参考地址:http://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_9014.htm#SQLRF01604
估计是你懒,可以考虑 1.每个字段先独自成表(不是真表,一个sel) 2.笛卡尔积去连接 3.insert into ..select.. 写了个简单的,不知道是不是你要的(仅有2个字段)select id1, id2 from ( select 1 id1 from dual union all select 2 id1 from dual union all select 3 id1 from dual )t1, ( select 2 id2 from dual union all select 3 id2 from dual union all select 4 id2 from dual )t2 where 1=1结果是:1 2 1 3 1 4 2 2 2 3 2 4 3 2 3 3 3 4
貌似你可以使用insert all when 完成。
参考地址:http://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_9014.htm#SQLRF01604
1.每个字段先独自成表(不是真表,一个sel)
2.笛卡尔积去连接
3.insert into ..select..
写了个简单的,不知道是不是你要的(仅有2个字段)select id1, id2
from
(
select 1 id1 from dual union all
select 2 id1 from dual union all
select 3 id1 from dual
)t1,
(
select 2 id2 from dual union all
select 3 id2 from dual union all
select 4 id2 from dual
)t2
where 1=1结果是:1 2
1 3
1 4
2 2
2 3
2 4
3 2
3 3
3 4