with as执行无结果 why

haihaiff

plsql develo8最新版本
with t_with as (select * from dual) select * from t_with;
PL/SQL Release 11.1.0.7.0 - Production
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0  均无结果

有人遇到过吗

haihaiff

select * from (with t_with as (select * from dual) select * from t_with);
这样才行

renxiao2003

学习了。这个语法。

renxiao2003

1#，2#的结果是一样的：
SQL> with t_with as (select * from dual) select * from t_with;

D
-
X

SQL> select * from (with t_with as (select * from dual) select * from t_with);

D
-
X

SQL>