Can sql loader update existing records in a table ??

I'm new to the bulk utilities of oracle.  I need to import records from a flat file.  Somtimes this file can contain records that may already exist in the database.  How do I deal with this ?
buckrodgerAsked:
Who is Participating?
 
lwadwellConnect With a Mentor Commented:
Hi buckrodger,

No, SQL Loader just does inserts.  It supports four methods INSERT/APPEND/REPLACE/TRUNCATE:
The default is INSERT - which does just that, inserts the data, but expects the table to be empty first.
You can APPEND to the end of the table;
The final two are REPLACE and TRUNCATE.  With these the entire table will be erased before loading.

If you need to update existing data in a table from a file you can load the data into a another table first and then update the target table using a custom script or merge statement.

lwadwell
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.