Home » RDBMS Server » Server Utilities » Extract decimals through SQL*Loader
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.
Previous Topic: Help!!!!!!
Next Topic: Ignoring fields in comma delimited file
Goto Forum:
  


Current Time: Thu Mar 28 09:22:39 CDT 2024