Skip to Main Content
Forums

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!

Need to check data accuracy from table A to B

NagaApr 2 2010 — edited Apr 2 2010
Hi,
I have table A (with 200 columns) and table B (with 210 columns, in this 200 column names and data type are same as table A, in addition to this i am populating 10 columns). I am populating records from A to B using procedure, now i want to cross check whether all the columns are being populated accuratly from table A to B (at least 1 record). I don't want to have 200 columns in a where condition, is there any other way to do this.

Thanks,
Naga
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 30 2010
Added on Apr 2 2010
2 comments
705 views