Home » RDBMS Server » Server Utilities » How to update records of oracle table with data file based on condition?
How to update records of oracle table with data file based on condition? [message #70110] Mon, 15 April 2002 17:55 Go to next message
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!
Re: How to update records of oracle table with data file based on condition? [message #70285 is a reply to message #70110] Sun, 19 May 2002 23:32 Go to previous message
Shobhit Khanna
Messages: 1
Registered: May 2002
Junior Member
I have the same question but haven't found any answers. It would be great if someone could help.

Thanks.
Previous Topic: Re: FREE OCP PAPERS
Next Topic: database problem
Goto Forum:
  


Current Time: Thu Mar 28 05:39:18 CDT 2024