Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Comparing Ora tables
Hi
I have table A and B with the foll. structure.
Table A - 6 varchar2 columns Table B - 6 varchar2 columns ------------------ ------------------------------- A1 B1 A2 B2 A3 B3 C1 D1 C2 D2 C3 D3 ------------------ ----------------------
Table B is a look up Table.
Table B will have non-null values for C1, C2 and C3 always and D1, D2, D3 could be Nulls at times.
Table A will have values such as,
A1 B1 NULL NULL NULL NULL or
A1 B1 A2 B2 NULL NULL or
A1 B1 A2 B2 A3 C3
The task is that for every record in table A, the existence of an equivalent record in table B has to be checked.
The equivalent record is considered to be present in Table B when,
all non-null fields of the record in Table A are equal to their corresponding fields in Table B.
Could someone give a way to do this with PL/SQL? There will be 10000s of records in Table A. So i want to know if there is any other way than Dynamic queries for this purpose.
Thanks
--
Nandakumar
New York
(N.Kumar_at_rocketmail.com)
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.
Received on Tue Jul 27 1999 - 12:36:21 CDT