with clause for subquery factoring
From: <web_poster03_at_yahoo.com>
Date: 4 Apr 2005 19:47:46 -0700
Message-ID: <1112669266.018887.158100_at_z14g2000cwz.googlegroups.com>
Hi,
select * from free_space_by_tablespace ;
select * from free_space_by_tablespace
)
Date: 4 Apr 2005 19:47:46 -0700
Message-ID: <1112669266.018887.158100_at_z14g2000cwz.googlegroups.com>
Hi,
The following does not return result:
with free_space_by_tablespace as
( select sum(bytes)/1024 Kbytes_free,
max(bytes)/1024 largest, tablespace_name from sys.dba_free_space group by tablespace_name
select * from free_space_by_tablespace ;
BUT this does:
select * from (with free_space_by_tablespace as
( select sum(bytes)/1024 Kbytes_free,
max(bytes)/1024 largest,
tablespace_name
from sys.dba_free_space
group by tablespace_name
select * from free_space_by_tablespace
)
What is wrong with my query?
Is it due to the version problem on my client software? My Oracle server is 9.2 and above
Thanks for any points on this. Received on Tue Apr 05 2005 - 04:47:46 CEST