create a trigger "on insert" to fill the second field,
and use SQLlOADER to fill the first one.
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
Received on Thu Jun 05 2003 - 09:17:32 CDT
