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