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!

reading flat file and comparing with the table data

711216Feb 15 2010 — edited Feb 16 2010

Dear all,

I have a flat file of below data say TEST.csv placed in the local system PATH(C:/TEST.csv) and i have a database(oracle 9i) table sample_test_data having the same flat file columns data.

Now i need to compare the TEST.csv file data with the table sample_test_data, if emp name and empno is same then i have to display a message.

kindly please provide me some inputs how can i achieve this.

TEST.csv

Empname empno deptname
smuel 1003 LS
Llly 1002 PS

Regards,
Kiran

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 16 2010

Added on Feb 15 2010

5 comments

2,017 views