SQL-Loader

From: niesten <member30732_at_dbforums.com>
Date: Thu, 05 Jun 2003 08:22:40 +0000
Message-ID: <2961656.1054801360@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

--
Posted via http://dbforums.com

Received on Thu Jun 05 2003 - 03:22:40 CDT