Re: SQL*Loader Question - please
Date: Sun, 01 Jun 2003 10:02:47 GMT
Message-ID: <bbkCa.25139$pR3.501649_at_news1.tin.it>
[Quoted] Below you can find a couple of control files loading the data in the
required format.
The former is using field separators, just in case you want to try another
method, while the latter uses fixed positions. You can see also that DECIMAL
[Quoted] EXTERNAL or FLOAT EXTERNAL do not affect the loaded values in any way.
Both control files work as expected either with direct path or conventional
[Quoted] path, are you sure you're specifying the right POSITIONs?
Bye,
Flavio
create table test_dec (num1 number(14,2), num2 number(14,2));
- version 1
load data
infile *
into table test_dec
truncate
FIELDS TERMINATED BY ','
(num1 DECIMAL EXTERNAL,
num2 FLOAT EXTERNAL
)
BEGINDATA +000000000376.04, -000000000154.70
-000000000376.03, +000000000154.71
- version 2
load data
infile *
into table test_dec
truncate
(num1 POSITION(1:16) DECIMAL EXTERNAL,
num2 POSITION(17:32) FLOAT EXTERNAL
)
BEGINDATA +000000000376.04-000000000154.70
-000000000376.03+000000000154.71 Received on Sun Jun 01 2003 - 12:02:47 CEST