Home » RDBMS Server » Server Utilities » Sql loader (windows xp)
Sql loader [message #330404] Mon, 30 June 2008 01:52 Go to next message
Messages: 1
Registered: June 2008
Junior Member
Hi all ,
I'm very new to oracle Db , i'm using sql loader to load data from a file in to a specific table & it's going fine but what i wanna is to load data file through a condition for example : if emp_id = emp_id do update else insert....
so how can i do this by using sql loader ..

Please waiting the reply as soon as possible..

Re: Sql loader [message #330408 is a reply to message #330404] Mon, 30 June 2008 02:12 Go to previous messageGo to next message
Messages: 3186
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
It can't be done directly with SQL*Loader.

Two options you have are :

1. Use SQL*Loader to load the file into a staging table and then process the data in that staging table.

2. Use an external table instead of the command line SQL*Loader
Re: Sql loader [message #330410 is a reply to message #330408] Mon, 30 June 2008 02:15 Go to previous message
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

This has been adressed before, have a look at this link
Previous Topic: How to add extended values in control file
Next Topic: how to overwrite the table name
Goto Forum:

Current Time: Sun Oct 23 11:19:11 CDT 2016

Total time taken to generate the page: 0.08630 seconds