Re: SQL-Loader

From: FC <flavio_at_tin.it>
Date: Thu, 05 Jun 2003 12:56:09 GMT
Message-ID: <J5HDa.76196$g92.1739929@news2.tin.it>

"niesten" <member30732_at_dbforums.com> wrote in message news:2961656.1054801360_at_dbforums.com...
>
> I've got a semicolon separated file that I have to load into an Oracle
> table with SQL-Loader. There is one field in the file (phone) I have to
> use twice. One time as it is in the file (e.g. 31612345678) and one time
> without the country code (e.g. 612345678). (So the second time I have to
> get the last 9 chars from the field).
>
> Can anyone tell me how to use the same field twice? (Take care that it
> is a semicolon separated file and not a fixed width file)
>
> Thanks in advance.
>
> Roger Niesten
>

The second time you can refer to the table column you just retrieved and apply a SQL function to strip out unwanted characters (digits). This method is not working using direct path load.

Bye,
Flavio Received on Thu Jun 05 2003 - 07:56:09 CDT