Hi All,
I had an urgent requirement and i hope you will answer me and thanks a lot.
I had two tables (one is custom table i created and another is base table).I created the custom table based upon the base table columns.
Now,my requirement is that i need to write a script that compares these two table columns and if there is difference in the tables,we need to capture the difference in another table (third table).
Eg:
Say i had person salary as x in table1 for particular person and the salary for this person in table2 is y.So,i need to capture these two columns information in third table.
Can you please send me your valuable suggestions ASAP.
Pl/Sql script to compare two tables
-
- Posts: 10
- Joined: Sat Nov 22, 2008 11:21 pm
- Location: USA
Who is online
Users browsing this forum: No registered users and 24 guests