Re: Start With Connect by usage without Prior keyword

"Christian" <ccote_msl_at_yahoo.com> wrote in message news:992a9b5a.0406080846.6ad36d37_at_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

no reasonable usage that i can see, but it does appear that the where-as the syntax is not checked, any statement that leaves out the PRIOR (cannot leave out the CONNECT BY) will either return no rows or will raise 'ORA-01436: CONNECT BY loop in user data'

++ mcs Received on Thu Jun 17 2004 - 02:20:36 CDT