| update and insert using sql loader [message #73408] |
Sat, 17 April 2004 09:56  |
Rohit Sharma
Messages: 4
Registered: May 2002
|
Junior Member |
|
|
|
I need to insert some new data and update the exisitng data in a table. The complete set of data is in a flat file. Can it be done through sql loader. If not, is their any other way this can be done.
|
|
|
|
| Re: update and insert using sql loader [message #73409 is a reply to message #73408] |
Sat, 17 April 2004 10:32  |
 |
Barbara Boehmer
Messages: 9097
Registered: November 2002
Location: California, USA
|
Senior Member |
|
|
|
SQL*Loader does not do updates. You can use SQL*Loader to load into a staging table, then do your upates from there. Or, if you are using Oracle version 9i, then you can use external tables, instead of SQL*Loader, and access your flat file as if it were a table, then you can insert, update, and merge from there.
|
|
|
|
|
|
| Re: How to use sql*loader [message #73486 is a reply to message #73485] |
Mon, 10 May 2004 22:04 |
|
Barbara Boehmer
Messages: 9097
Registered: November 2002
Location: California, USA
|
Senior Member |
|
|
Please click on the link below for the section of the database utilities guide regarding SQL*Loader within the Oracle online documentation. The case studies in chapter 10 are excellent examples.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
