关于with as 的问题？

显示全部楼层 · 2014-2-19 11:55:14

with
aa as ( select 1 from dual )
select * from aa
;
这段sql语句为什么返回0行记录？

千问 · 2014-2-19 11:55:14

SQL> with
2aa as ( select 1 from dual )
3select * from aa
4;
1
----------
1
SQL> SELECT * FROM V$VERSION;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE
10.2.0.1.0
Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production

千问 · 2014-2-19 11:55:14

我显示的是：
SELECT * FROM V$VERSION;
BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production
PL/SQL Release 9.2.0.6.0 - Production
CORE
9.2.0.6.0
Production
TNS for IBM/AIX RISC System/6000: Version 9.2.0.6.0 - Production
NLSRTL Version 9.2.0.6.0 - Production