RE: ** using decode in sql loader

  • From: "Yasin Baskan" <yasbs@xxxxxxxxxxxxxx>
  • To: <ajoshi977@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 4 Feb 2005 15:35:05 +0200

You can use something like this.

OVERDATE               POSITION(138:145) CHAR

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of A Joshi
Sent: Friday, February 04, 2005 1:43 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: ** using decode in sql loader

  I would like to use decode in sqlloader to convert data. I have a date
field that might have the text 'current' in which case I want to convert
it into sysdate. Can that be done? Thanks for your help.=20
Do you Yahoo!?
 Yahoo! Search presents - Jib Jab's 'Second Term'


Other related posts: