| Problems with data type during import [message #70272] |
Fri, 17 May 2002 03:21  |
Jochen
Messages: 6
Registered: December 2000
|
Junior Member |
|
|
Hi folks,
I'm trying to import weather data via sqlldr. The data type of the temperature column is set to NUMBER. The problem: all temperature values with an decimal point (1.2 or -1.2) get lost during import. I can only import integer values. What´s wrong. Please help.
Thanks in advance
Jochen
|
|
|
|
| Re: Problems with data type during import [message #70296 is a reply to message #70272] |
Tue, 21 May 2002 07:40  |
Grant
Messages: 578
Registered: January 2002
|
Senior Member |
|
|
|
You need to create the column using NUMBER(p,s). Numbers having precision and scale. p ranges from 1 to 38. s ranges from -84 to 127. So if you created a number using NUMBER(9,2) it would hold 9 positions and two after the decimal.
|
|
|
|
| Problem solved [message #70309 is a reply to message #70296] |
Thu, 23 May 2002 05:58 |
Jochen
Messages: 6
Registered: December 2000
|
Junior Member |
|
|
I have a German Oracle. I replaced the decimal point with a comma an the import worked out fine. Thanks for your commitment.
Jochen
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
