| Insert/Update facillity in loader [message #186541] |
Tue, 08 August 2006 07:19  |
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
