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>


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?


Adar Yechiel
Rechovot, Israel


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

Original text of this message