Re: sql loader help
Date: Thu, 20 Aug 2009 08:57:55 +0300
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.
Yechiel Adar wrote:
> 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?