RE: ** using decode in sql loader

From: Knight, Jon <jknight_at_concordefs.com>
Date: Thu, 3 Feb 2005 17:50:23 -0600
Message-ID: <17ECCBDCF27C544583F2CAD928F953261A54C1@memex1.corp.cefs.int>

It looks like you can.

>From Oracle's documentation:

field1 POSITION(1:4) INTEGER EXTERNAL

       "decode(:field2, '22', '34', :field1)"

Jon Knight

 -----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of A Joshi

Sent:	Thursday, February 03, 2005 5:43 PM
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.                 

---

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 Thu Feb 03 2005 - 18:53:09 CST