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