Yes
On Jul 17, 1:36 pm, Rob Wolfe <wolfe....@gmail.com> wrote:
> On Jul 16, 11:29 pm, David09 <mykhis...@gmail.com> wrote:
>
>
>
> > I'm trying to find set of data mentioned from table TP1. I'm trying to
> > retrieve this record through sql query so i'm finding it very
> > difficult. Is there any better way to find the set of data from this
> > table?
>
> > On Jul 17, 1:13 pm, Rob Wolfe <wolfe....@gmail.com> wrote:
>
> > > On Jul 16, 11:02 pm, David09 <mykhis...@gmail.com> wrote:
>
> > > > 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.
>
> > > What are you asking and why do you think this is a complex self join?
>
> so let me see if I have this right
> you want the record(s) with (id1=1234 and id2=9807) or with ( id1=6746
> and id2=2528) or with (all those other combinations you have listed)
> correct?
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
