Re: Materialize hint

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@win where rownum <
1000)

  2  select a.*,b.* from myrows a,myrows b;

with myrows as (select rownum i from dba_objects@win where rownum < 1000)

                                                    *

ERROR at line 1:

ORA-00604: error occurred at recursive SQL level 1

ORA-00933: 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@xxxxxxxxxxxxxxxxxx>
To: "oracle-l" <oracle-l@xxxxxxxxxxxxx>
Sent: Monday, December 27, 2004 6:41 PM
Subject: Re: Materialize hint




--
http://www.freelists.org/webpage/oracle-l

Other related posts: