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

Home -> Community -> Usenet -> comp.databases.theory -> Re: SELECT & recursion

Re: SELECT & recursion

From: Bart Wakker <bhawa_at_web.de>
Date: Wed, 22 Mar 2006 12:33:39 +0000
Message-ID: <slrne22h13.cbq.bhawa@bhawa.web.de> 





On 2006-03-21, vc <boston103_at_hotmail.com> wrote:



> You are confused -- the way 'connect by' behaves in your examples is

> just the opposite to what you've described.

>




Indeed.



The DB2 solution using WITH, doesn't work for oracle b.t.w.: the result is
ORA-32031: illegal reference of a query name in WITH clause.
Received on Wed Mar 22 2006 - 06:33:39 CST












Original text of this message













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