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_at_posting.google.com>
HI,
Is there a usage for something like this:
Connect By Prior MyCol = MyOtherCol
Date: 8 Jun 2004 09:46:52 -0700
Message-ID: <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
Connect By Prior MyCol = MyOtherCol
Thank you,
Christian Cote
Received on Tue Jun 08 2004 - 18:46:52 CEST