If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Hybrid View

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.