I have around 10 million records in table TP1. My database version is
9.2.0.5

Table TP1:
======
Id1 number (10);
Id2 number (10);

I want to find the following set of data from this table

Id1             Id2
===           ===
1234          9807
9807          1234

Id1             Id2
===           ===
4567          2502
2502          7945
7945          4567

Id1             Id2
===           ===
2528          4261
4261          5489
5489          6746
6746          2528

How do I retrieve these records set? Thanks in advance for your help.

--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---

Reply via email to