Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: cannot have subqueries in CONNECT BY clause

Re: cannot have subqueries in CONNECT BY clause

From: Alexander V. Silantiev <silantiev_at_bashkortostan.ru>
Date: Wed, 21 Nov 2001 18:03:37 +0500
Message-ID: <9tg8ju$al3$1@poikc.bashnet.ru> 





It's correct answer.


Thank you.


Would you explain why this difference exists?
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')?
Received on Wed Nov 21 2001 - 07:03:37 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US