> 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)
