How to update records of oracle table with data file based on condition? [message #70110] |
Mon, 15 April 2002 17:55 |
Wilson
Messages: 9 Registered: February 2002
|
Junior Member |
|
|
I want to ask can sqlloader be used to update records of oracle table with data file? say there are three columns in data file: fileColumnA, fileColumnB, fileColumnC. Also, there are three columns in oracle table: oracleColumnA, oracleColumnB, oracleColumnC.
When data in fileColumnA and oracleColumnA are same, data in oracleColumnB and oracleColumnC are updated with fileColumnB and fileColumnC.
Does anyone know how to write this logic in the control file? thank you very much!
|
|
|
|