Home » RDBMS Server » Server Utilities » Insert/Update facillity in loader
Insert/Update facillity in loader [message #186541] Tue, 08 August 2006 07:19 Go to next message
rnairroh
Messages: 1
Registered: August 2006
Location: Mumbai
Junior Member
Hi Friends,

I have a file in Unix which i need to load into a table. But there are some conditions for doing so ....

For eg : the file has following columns ;

Mkt_Id Mrkt_Name
CA Canada
IN India

1> While loading this file into the table, i need to check if there exists a record in the table for a particular market ID.... If it exists then i have to updatte the record in the table.

2> If the market_id from the file is not present in the table then i need to insert this record into the table....

Is there anyway this can be done using SQL LOADER ??

If not .. then any other way , that i can achieve this .....

Thanks in advance
Re: Insert/Update facillity in loader [message #186545 is a reply to message #186541] Tue, 08 August 2006 07:31 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Sql*loader cannot update.
Please search the forum before posting.
http://www.orafaq.com/forum/t/67450/42800/

Workaround is to load the data as is and use sql means
or
use external tables.
Previous Topic: Copy data from one oracle server to another
Next Topic: daily incremental loading
Goto Forum:
  


Current Time: Wed Dec 07 12:25:14 CST 2016

Total time taken to generate the page: 0.22085 seconds