Extract decimals through SQL*Loader [message #368016] |
Mon, 04 October 1999 19:01 |
sailaja
Messages: 11 Registered: October 1999
|
Junior Member |
|
|
I have a flat file (CSV format). The numberfields are like 45.56,24.20,34.00
In the control file defination the number fields are defined as PRICE DECIMAL EXTERNAL.
In the table the column PRICE is NUMBER(8,2).
This works , but the problem is I need two digits after the decimal always.
e.g 45.56 comes as 45.56 but 24.20 comes as 24.2
and 34.00 comes as 34.
I would appreciate any answers.
Thanks in advance,
Sailaja.
|
|
|