flat file comparison with Oracle table

Hi,

What is the most efficient way to compare flat file with table in Oracle?

I was thinking of creating a temp table, but the issue is how do I get the values into the temp_table from the flat file other than using MS Access and linking table together and finaly executing the append query.

Thanks

9i use external table, 8i/9i use utl_file

steve

Is there any way you can give me a simple example?

Thanks

what db version?

steve

9i

Thanks

I have found this to be a good example

http://otn.oracle.com/oramag/oracle/...o12advice.html


steve

thanks