Ubiquitous wrote:
>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.
>
>
>
Use the SUBSTR function in SQL*Loader. If you don't know how ... go to
tahiti.
--
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Fri Sep 19 2003 - 22:37:37 CDT
