Pl/Sql script to compare two tables
Posted: Tue Jul 13, 2010 11:27 pm
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.
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.