Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Comparing Ora tables

Comparing Ora tables

From: Nandakumar <nanban_at_my-deja.com>
Date: Tue, 27 Jul 1999 17:36:21 GMT
Message-ID: <7nkqmk$f6d$1@nnrp1.deja.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US