Force sql*loader to load decimal data with point not comma
440307Mar 16 2005 — edited Mar 17 2005Example:
CREATE TABLE TEMP(
TEMP_ID INTEGER;
TEMP_DATA DECIMAL(9,6)
)
File with data (for example temp.dat):
â1â,â34,67â
â2â,â56,87â
Control file for sql*loader(for example temp.ctl)
LOAD DATA
INFILE temp.dat
INTO TABLE TEMP
FIELDS TERMINATED BY ","
OPTIONALLY ENCLOSED BY '"'
(TEMP_ID INTEGER EXTERNAL;
TEMP_DATA DECIMAL EXTERNAL)
This example is working very well.
If I change loaded data and replace comma for dot(I have data like this, look below)
â1â,â34.67â
â2â,â56.87â
I can not load those to table temp, for example.
How can I force sql*loader to load decimal data with dot?
Thank you.
(Win xp with oracle 10g)