Re: Start With Connect by usage without Prior keyword

"Mark C. Stock" <mcstockX_at_Xenquery .com> wrote in message news:<_uGdnQE3wrDO20zd4p2dnA_at_comcast.com>...
> "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'

select rownum from dual connect by rownum < 100

I'm not sure about the earlier versions but since 9.2 it certainly won't give you 'ORA-01436'. Received on Thu Jun 17 2004 - 19:50:45 CEST