Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: ** using decode in sql loader

RE: ** using decode in sql loader

From: A Joshi <ajoshi977_at_yahoo.com>
Date: Thu, 3 Feb 2005 20:02:48 -0800 (PST)
Message-ID: <20050204040248.71919.qmail@web60707.mail.yahoo.com>


Thank you Jon.  

the question is how can I specify sysdate in place of '34' in the example below.  

Please note that it is a date field :  

decode(:field1, 'current','<i want sysdate here>', :field1) i tried :sysdate and ':sysdate' and no luck. Thanks "Knight, Jon" <jknight_at_concordefs.com> wrote: 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


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

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Feb 03 2005 - 23:05:27 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US