RE: sql loader help

From: Mercadante, Thomas F (LABOR) <"Mercadante,>
Date: Wed, 19 Aug 2009 08:46:56 -0400
Message-ID: <ABB9D76E187C5146AB5683F5A07336FF02BA38A0_at_EXCNYSM0A1AJ.nysemail.nyenet>

Sorry - I read "data" field rather than "date" field.

Same concept though:

column_name position(xx:xx) char
"to_date(decode(:column_name,'00000000', '19000101',:column_name),'yyyymmdd')",

Tom

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

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Mercadante, Thomas F (LABOR)
Sent: Wednesday, August 19, 2009 8:42 AM To: adar666_at_inter.net.il; ORACLE-L
Subject: RE: sql loader help

Adar,

How about:

column_name position(xx:xx) char "decode(:column_name,'00000000', '19000101',:column_name)",

Tom

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

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Yechiel Adar Sent: Wednesday, August 19, 2009 8:33 AM To: ORACLE-L
Subject: sql loader help

Hello

I have date data in a record from txt file. When the field in the record contain '00000000' I want to replace it with '19000101'.
How can I convince sql loader to do this?

TIA
--

Adar Yechiel
Rechovot, Israel

--

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

--

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

--

http://www.freelists.org/webpage/oracle-l Received on Wed Aug 19 2009 - 07:46:56 CDT