We have a customer database that gets updated every week with Change
or Add records. We receive files with various fields. Suppose, we
get a Customer ID that matches our database. Is there a way to
develop a query or plsql that will tell us the fields that are
different between the two records?
For example, suppose we have the following two records:
CUSTID LNAME FNAME DOB ACQ_DATE BRANCH
12345 SMITH JOHN 12/15/74 01/01/02 1178
12345 SMITH JOHN 01/01/02 1187
Is there a way to determine that the DOB and BRANCH fields are
different for this customer? This is very important for our process
in order to determine the priority level of an update. We receive too
many records to visually inspect them all. Please help.
Thank You,
Pedro Mercado
mercadop_at_expertx.com