Home » RDBMS Server » Server Administration » Connect by
Connect by [message #374113] Fri, 25 May 2001 07:55
David
Messages: 110
Registered: November 1998
Senior Member
How can I traverse over a circular(!) table using CONNECT BY without getting the ORA-01436 ?

For example, if I have a table like this:

parent child
----- -----
1 2
2 1
2 3
3 2
4 5
5 4

how can I get a result like { 1 , 2 , 3 } if I'm starting with parent = 1 ?

Report message to a moderator

Previous Topic: Sqlplus command file path containing spaces.
Next Topic: Connect by
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Jul 03 17:00:44 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.