RE: ** using decode in sql loader

From: Yasin Baskan <yasbs_at_kocbank.com.tr>
Date: Fri, 4 Feb 2005 15:35:05 +0200
Message-ID: <083667B535F3464CA0DD0D1DAFA4E37604DFE1B5@camexc1.kfs.local>

You can use something like this.

OVERDATE POSITION(138:145) CHAR "decode(:overdate,'current',sysdate,to_date(:overdate,'DDMMYYYY'))"

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of A Joshi Sent: Friday, February 04, 2005 1:43 AM
To: oracle-l_at_freelists.org
Subject: ** using decode in sql loader

Hi,
  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

        =09

---

Do you Yahoo!?
 Yahoo! Search presents - Jib Jab's 'Second Term'

--

http://www.freelists.org/webpage/oracle-l
--

http://www.freelists.org/webpage/oracle-l Received on Fri Feb 04 2005 - 08:37:33 CST