Home » RDBMS Server » Server Utilities » create loader file to append data and update existing rows.
create loader file to append data and update existing rows. [message #73176] Wed, 25 February 2004 15:15 Go to next message
Sanjay
Messages: 236
Registered: July 2000
Senior Member
Hi,

I am trying to create a loader file that will allow me to append data to a table if the primary key does not exist and if the primary key exists in the table then to just update that row.

For example, append employee rows to the employee table from the loader file, else if the employee_number exists in the employee table then just update the employee details on the table with the employee details from the loader file.

Does anyone know how to do this?

Thanks for your help on this.

Report message to a moderator

Re: create loader file to append data and update existing rows. [message #73181 is a reply to message #73176] Thu, 26 February 2004 02:44 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
sql*loader WILL NOT do the update.
u have to use a trigger in the background.
or
load all records into another temp table.
from that temp table u can do whatever u want using sql

Report message to a moderator

Previous Topic: Oracle 904 error while dumping
Next Topic: How to find db size, blah blah...
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jun 29 05:16:07 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.