| SQL LOader [message #69201] |
Tue, 20 November 2001 23:37  |
Srinivasan.R
Messages: 1
Registered: November 2001
|
Junior Member |
|
|
Hi all,
Am using SQL loader to load data from Text file to Oracle database.
While loading the records, some of them may already exist in the database, in that case i want to update the database with the new infor from the text file.
How can i acheive this in my SQL loader control code.
Thanks in advance!!
RSrinivasan
----------------------------------------------------------------------
|
|
|
|
| Re: SQL LOader [message #69203 is a reply to message #69201] |
Wed, 21 November 2001 03:41  |
Suresh Vemulapalli
Messages: 624
Registered: August 2000
|
Senior Member |
|
|
load data into interface tables and write pl/sql block to process data in interface tables.you can drop those interface tables once your operation is done.
----------------------------------------------------------------------
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
