470,636 Members | 1,565 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,636 developers. It's quick & easy.

Start With Connect by usage without Prior keyword

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
Jul 19 '05 #1
2 7984

"Christian" <cc*******@yahoo.com> wrote in message
news:99**************************@posting.google.c om...
| 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
Jul 19 '05 #2
"Mark C. Stock" <mcstockX@Xenquery .com> wrote in message news:<_u********************@comcast.com>...
"Christian" <cc*******@yahoo.com> wrote in message
news:99**************************@posting.google.c om...
| 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'.
Jul 19 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by vikas.bhatia | last post: by
6 posts views Thread by RdS | last post: by
3 posts views Thread by Ehsan | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.