Re: sql loader help
From: Yechiel Adar <adar666_at_inter.net.il>
Date: Thu, 20 Aug 2009 08:57:55 +0300
Message-id: <4A8CE5E3.3010109_at_inter.net.il>
Thank you all.
I decided to use the "edit the data file" advice. This is windows so sed will not work, but I used change.exe instead and it works now fine.
Date: Thu, 20 Aug 2009 08:57:55 +0300
Message-id: <4A8CE5E3.3010109_at_inter.net.il>
Thank you all.
I decided to use the "edit the data file" advice. This is windows so sed will not work, but I used change.exe instead and it works now fine.
Adar Yechiel
Rechovot, Israel
Yechiel Adar wrote:
> 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
>
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Aug 20 2009 - 00:57:55 CDT