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

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

with myrows as (select rownum i from dba_objects_at_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_at_jlcomp.demon.co.uk> To: "oracle-l" <oracle-l_at_freelists.org> Sent: Monday, December 27, 2004 6:41 PM Subject: Re: Materialize hint

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