Problem in sql loader [message #70981] |
Thu, 22 August 2002 04:48 |
krishna
Messages: 141 Registered: October 1998
|
Senior Member |
|
|
I have a case in sql loader.
If sql loader encounters a particular record in the first column in datafile, I want it to refer to the value in another column for that particular record.
What is the syntax for this condition?
For example, this is my datafile
Column1 column2 column3
01 02 03
07 09 10
AA 08 06
Whenever sql loader encounters AA i want it to refer to column3 i.e it should pick up 06.
|
|
|
That will slow down your load [message #70992 is a reply to message #70981] |
Fri, 23 August 2002 18:44 |
Eric Myers
Messages: 13 Registered: August 2002
|
Junior Member |
|
|
Don't know the syntax to do that, but I do want to point out that such decision making done during the load will have significant impact on performance. Will also force you to use conventional path loading - i.e., you can't use direct path loading which is much faster.
I would recommend you check the data before it goes into the file and change it before you use the file as input to SQL*Loader.
|
|
|