RE: ** using decode in sql loader
- From: A Joshi <ajoshi977@xxxxxxxxx>
- To: jknight@xxxxxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Thu, 3 Feb 2005 20:02:48 -0800 (PST)
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@xxxxxxxxxxxxxx> 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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of A Joshi
Sent: Thursday, February 03, 2005 5:43 PM
To: oracle-l@xxxxxxxxxxxxx
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'
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
---------------------------------
Do you Yahoo!?
Yahoo! Search presents - Jib Jab's 'Second Term'
--
//www.freelists.org/webpage/oracle-l
Other related posts:
