oracle with as 问题

[ww33cc]

请高手帮忙解决下：

with a as
(select 1, 2 from dual),
b as
(select 3, 4 from dual)
insert into dual select a.*, b.* from a, b;

报错：缺少select 关键字

为什么？ 在线等。

[hanzs]

--加insert into dual做什么？改下试试
with a as
(select 1, 2 from dual),
b as  
(select 3, 4 from dual)
select a.*, b.* from a, b;

[ww33cc]

2 楼的写法自然是没问题。 我想要的结果是 insert

[ww33cc]

1 楼的写法没问题。 我想要的结果是insert。 有这样的需求。。。

[hanzs]

你要insert，那你也不能insert到dual，你要写实际的表啊，还有就是字段对应了吗？

[ww33cc]

我就是在实际的应用中碰到了这样的问题。 写了个小demo还是这样的问题， 报的错也是一样！

[ww33cc]

换种写法 没问题。

insert into XXX select a.*, b.* from (select 1, 2 from dual) a, (select 3, 4 from dual) b;

[BenChiM888]

insert into dual
with a as
(select 1, 2 from dual),
b as  
(select 3, 4 from dual)
select a.*, b.* from a, b;

[li26338710]

可以向dual表 插数据吗？

[BenChiM888]

insert into XXX
with a as
(select 1, 2 from dual),
b as  
(select 3, 4 from dual)
select a.*, b.* from a, b;

[Quote=引用 7 楼 benchim888 的回复:]
SQL code

insert into dual
with a as
(select 1, 2 from dual),
b as
(select 3, 4 from dual)
select a.*, b.* from a, b;
[/Quote]

[ww33cc]

谢谢， 解决了。。。