单位服务器是10g版本
我用with as 为什么差不多数据呢?
比如:
with v as
(select * from t)
select * from v以上语句应该同select * from t是等效的吧,但是却查不到数据。
我google了下,with as 是sql-99标准的,oracle 从9i r2开始就支持with as了
请大牛指点
我用with as 为什么差不多数据呢?
比如:
with v as
(select * from t)
select * from v以上语句应该同select * from t是等效的吧,但是却查不到数据。
我google了下,with as 是sql-99标准的,oracle 从9i r2开始就支持with as了
请大牛指点
select * from t就能查到
是否 commit
那我也不知道什么情况了
语句后面怎么没加分号呢下面是我在SQL*PLUS里执行的 参考一下
SQL> select * from t1; ID1 ID2
---------- ----------
1 1
1 2
2 2
3 1
3 2SQL> with v as
2 (select * from t1)
3 select * from v
4 ; ID1 ID2
---------- ----------
1 1
1 2
2 2
3 1
3 2SQL>
with v1 as
(select ...)
v2 AS
(select ... from v1)
select ...
SQL> select * from t1; ID1 ID2
---------- ----------
1 1
1 2
2 2
3 1
3 2SQL> with v1 as
2 (select id1 from t1)
3 select * from v1; ID1
----------
1
1
2
3
3SQL> with v1 as
2 (select id1 from t1)
3 v2 as
4 (select id2 from t1)
5 select * from v1,v2;
v2 as
*
ERROR at line 3:
ORA-00928: missing SELECT keyword
2 (select id1 from t1),
3 v2 as
4 (select id2 from t1)
5 select * from v1,v2;