Materialize hint 2004-12-29 - By jaromir nemec
Hi,
> In reverse order, the "with " clause names
> and defines a subquery before its use in
> a query - a bit like a macro in C.
I 'd see very valuable a constellation with "*distributed* subquery
factoring ". I found no restriction on this in documentation, but have no
luck using it (on 9.2.0.5)
SQL > with myrows as (select rownum i from dba_objects@(protected) where rownum <
1000)
2 select a.*,b.* from myrows a,myrows b;
with myrows as (select rownum i from dba_objects@(protected) where rownum < 1000)
*
ERROR at line 1:
ORA-00604 (See ORA-00604.ora-code.com): error occurred at recursive SQL level 1
ORA-00933 (See ORA-00933.ora-code.com): SQL command not properly ended
Is it a bug or a restriction?
Regards
Jaromir D.B. Nemec
http://www.db-nemec.com
-- -- Original Message -- --
From: "Jonathan Lewis " <jonathan@(protected) >
To: "oracle-l " <oracle-l@(protected) >
Sent: Monday, December 27, 2004 6:41 PM
Subject: Re: Materialize hint
--
http://www.freelists.org/webpage/oracle-l
|
|
