Michael Freier wrote:
> Hello,
>
> I have the following file (2 line) which I want to intend in an oracle
> database with the SQL*Loader.
>
> tommy050+3423
> tom 070-0006
>
> The file consists of two lines and three columns.
>
> Column1 has always 5 digits and is a String. Additional empty digits will be
> filled with blanks. Here: "tommy" and "tom "
>
> Column2 has three digits and is a number. Here: "050" and "070".
>
> Column 3 is also a number and consists of four digits. Additionally there is
> a fifth digit for the leading sign ("+" or "-"). Here: "+3423" and "-0006".
>
> This file I want to import in my table "MyTab".
>
> MyTab(
> thing VARCHAR2(5)
> number NUMBER(3)
> amount NUMBER
> )
>
> How would the control file for the SQL*Loader look like for this example?
>
> Regards
>
> Michael
Morgan's Library at www.psoug.org
click on SQL*Loader
There are several demos that show how to do this.
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Fri Mar 03 2006 - 14:23:20 CST
