Re: sql loader help
- From: Andrew Kerber <andrew.kerber@xxxxxxxxx>
- To: adar666@xxxxxxxxxxxx
- Date: Wed, 19 Aug 2009 07:42:56 -0500
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@xxxxxxxxxxxx> 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
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
Andrew W. Kerber
'If at first you dont succeed, dont take up skydiving.'
Other related posts:
