| Sql loader [message #330404] |
Mon, 30 June 2008 01:52  |
sshehab
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..
Thanks
Sherif
|
|
|
|
| Re: Sql loader [message #330408 is a reply to message #330404] |
Mon, 30 June 2008 02:12  |
ThomasG
Messages: 3212
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
