On Jul 16, 11:01 pm, Rob Wolfe <wolfe....@gmail.com> wrote:
> you do realize that is a completely different question than you asked
> the first time I hope. And I am no more clear on what you want than I
> was the first time. Can you please give an actual example?
Possibly this is what you want:
SQL> create table tp1(
2 id1 number,
3 id2 number
4 );
Table created.
SQL>
SQL> insert all
2 into tp1
3 values(1234,9807)
4 into tp1
5 values(9807,1234)
6 into tp1
7 values(4567,2502)
8 into tp1
9 values(2502,7945)
10 into tp1
11 values(7945,4567)
12 into tp1
13 values(2528,4261)
14 into tp1
15 values(4261,5489)
16 into tp1
17 values(5489,6746)
18 into tp1
19 values(6746,2528)
20 select * from dual;
9 rows created.
SQL>
SQL> commit;
Commit complete.
SQL>
SQL> select id1, id2
2 from tp1
3 connect by nocycle id1 = prior id2
4 start with id1 = 1234
5 order by level;
ID1 ID2
---------- ----------
1234 9807
9807 1234
SQL>
SQL> select id1, id2
2 from tp1
3 connect by nocycle id1 = prior id2
4 start with id1 = 4567
5 order by level;
ID1 ID2
---------- ----------
4567 2502
2502 7945
7945 4567
SQL>
SQL> select id1, id2
2 from tp1
3 connect by nocycle id1 = prior id2
4 start with id1 = 2528
5 order by level;
ID1 ID2
---------- ----------
2528 4261
4261 5489
5489 6746
6746 2528
SQL>
David Fitzjarrell
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to Oracle-PLSQL@googlegroups.com
To unsubscribe from this group, send email to
oracle-plsql-unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
-~----------~----~----~----~------~----~------~--~---
