Re: cannot have subqueries in CONNECT BY clause

From: Nuno Souto <nsouto_at_optushome.com.au.nospam>
Date: Wed, 21 Nov 2001 13:42:41 GMT
Message-ID: <3bfbae85.17171764@news>

Alexander V. Silantiev doodled thusly:

>Would you explain why this difference exists?

Can't! I don't work for ORACLE! :-)

>By my mind, the principles of constructing views, joins must be common.
>Server should make the join at a run.
>Is there no definition how transform query in cases that raise errors
>('cannot have subqueries in CONNECT BY clause','cannot have join')?

My guess is that 9i does precisely that. With prior versions, hierarchical queries were not as well treated as with this version, vis-a-vis the optimizer.

Cheers
Nuno Souto
nsouto_at_optushome.com.au.nospam Received on Wed Nov 21 2001 - 07:42:41 CST