Re: SQL-Loader

In article <2961656.1054801360_at_dbforums.com>, member30732_at_dbforums.com wrote:

>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)

I believe there's a way to associate a PL/SQL command with the field such that you could use SUBSTR to fetch what you need from that column.

-- 
======================================================================
ISLAM: Winning the hearts and minds of the world, one bomb at a time.