Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

compare two tables to determine which column data is different

user7035408Sep 13 2013 — edited Sep 13 2013

We are doing a conversion into oracle and we pulled data 1 year ago to cleanse and load

we now pull any record that has been updated since the original extract--how can we determine which fields were updated?

I have seen multiple discussion about comparing each table but I want to compare each column and indicate for the record which columns got updated since oracle tables do not show the update only that they have changed


Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 11 2013
Added on Sep 13 2013
2 comments
209 views