sql loader help

From: Yechiel Adar <adar666_at_inter.net.il>
Date: Wed, 19 Aug 2009 15:33:27 +0300
Message-id: <4A8BF117.80200_at_inter.net.il>

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 Received on Wed Aug 19 2009 - 07:33:27 CDT

This message: [ Message body ]
Next message: Mercadante, Thomas F (LABOR): "RE: sql loader help"
Previous message: Laimutis.Nedzinskas_at_seb.lt: "putting standby into a backup mode"
Next in thread: Mercadante, Thomas F (LABOR): "RE: sql loader help"
Reply: Mercadante, Thomas F (LABOR): "RE: sql loader help"
Reply: Andrew Kerber: "Re: sql loader help"
Reply: Yechiel Adar: "Re: sql loader help"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message