Re: sql loader help

  • From: Yechiel Adar <adar666@xxxxxxxxxxxx>
  • 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.

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

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


Other related posts: