Re: Control file for SQL*Loader

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Fri, 3 Mar 2006 06:24:11 +0100
Message-ID: <4407d2fa$0$11652$626a54ce@news.free.fr>

"Michael Freier" <michi1976_at_gmx.de> a écrit dans le message de news: 46p5kpFc3gt4U1_at_individual.net...
| 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
|

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96652/ch10.htm#1006795

Regards
Michel Cadot Received on Thu Mar 02 2006 - 23:24:11 CST