Skip to Main Content
Forums

Oracle Database Discussions

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 table data with data in csv file

1038060Sep 4 2013 — edited Sep 4 2013

Hi, I have a database table with ~32 milj rows. I want to compare the data from a csv file(~ 1500000 rows) with the data in a specific database column. And as a result I want to see what rows exists in both the csv file and db and what records in csv file are unique. The text I'm searching for is VARCHAR2. I am not allowed to export the database table so that's not an alternative. This is also a production environment so one need to be careful not disturbing the production.

Rgds J

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 2 2013
Added on Sep 4 2013
#column, #general-database-discussions, #text
9 comments
2,393 views