Re: sql loader help

From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Wed, 19 Aug 2009 07:42:56 -0500
Message-ID: <ad3aa4c90908190542g5366a804y6c2dad33e1e5d93_at_mail.gmail.com>

Well, in this case, since it is a text file, I would recommend using a text editor on it before running sql loader. Some Unix guys could probably also give you a one line command to do it. Dont focus on Oracle as the only solution to the problem.

On Wed, Aug 19, 2009 at 7:33 AM, Yechiel Adar <adar666_at_inter.net.il> 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
>
> --
> Adar Yechiel
> Rechovot, Israel
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

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

Received on Wed Aug 19 2009 - 07:42:56 CDT