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

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

------解决方案--------------------
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;

------解决方案--------------------

可以向dual表 插数据吗？

------解决方案--------------------
SQL code

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