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
===
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 wrote:
> On Jul 16, 11:02
Yes
On Jul 17, 1:36 pm, Rob Wolfe wrote:
> On Jul 16, 11:29 pm, David09 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 ther
Sorry I should I have been more specific
In the following example
N0 > N1 4567 > 2502
N1 > N2 2502 > 7945
N2 > N0 7945 > 4567
If Id1 4567 matches in Id2 then
retrieve all the record set in between
On Jul 17, 1:48 pm, David09 wrote:
> Yes
&
