sql loader help

From: Yechiel Adar <adar666@xxxxxxxxxxxx>
To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
Date: Wed, 19 Aug 2009 15:33:27 +0300

Hello

I have date data in a record from txt file.

When the field in the record contain '00000000' I want to replace itwith '19000101'.

How can I convince sql loader to do this?

TIA

--
Adar Yechiel
Rechovot, Israel

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

Follow-Ups:
- RE: sql loader help
  - From: Mercadante, Thomas F (LABOR)
- Re: sql loader help
  - From: Andrew Kerber
- Re: sql loader help
  - From: Yechiel Adar

Other related posts:

» sql loader help - Yechiel Adar
» RE: sql loader help- Mercadante, Thomas F (LABOR)
» Re: sql loader help- Andrew Kerber
» RE: sql loader help- Mercadante, Thomas F (LABOR)
» Re: sql loader help- Jared Still
» Re: sql loader help- Yechiel Adar
» Re: sql loader help- Yechiel Adar
» Re: sql loader help- Jared Still
» Re: sql loader help- Yechiel Adar