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

Home -> Community -> Usenet -> comp.databases.oracle -> Start With Connect by usage without Prior keyword

Start With Connect by usage without Prior keyword

From: Christian <ccote_msl_at_yahoo.com>
Date: 8 Jun 2004 09:46:52 -0700
Message-ID: <992a9b5a.0406080846.6ad36d37@posting.google.com>


HI,
Is there a usage for something like this:

Select MyColumn
From MyTable
Start with MyCol = aNumber
Connect By MyCol = MyOtherCol

If not, its a bit weird that Oracle does not raise an error since the keyword PRIOR is not used like this:

 Select MyColumn
 From MyTable
 Start with MyCol = aNumber
 Connect By Prior MyCol = MyOtherCol

Thank you,
Christian Cote Received on Tue Jun 08 2004 - 11:46:52 CDT

Original text of this message

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