From: mcstockX@Xenquery   
      
   "Christian"  wrote in message   
   news: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   
      
   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   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)