Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Force sql*loader to load decimal data with point not comma

440307Mar 16 2005 — edited Mar 17 2005
Example:
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)
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 14 2005
Added on Mar 16 2005
2 comments
2,171 views