DATA MASK IN SQL LOADER [message #57433] |
Mon, 16 June 2003 02:52 |
A.Angelo
Messages: 1 Registered: June 2003
|
Junior Member |
|
|
Hello!
I have to load numeric types into a table, from a flat file, record fixed length.
More specific, in the target I have the numeric type NUMBER(12.2), while the source corresponding field is 14 chars wide, WITHOUT ANY DECIMAL SEPARATOR.
How do I specifiy the correct format of the number to be loaded?
Thanks!
|
|
|
Re: DATA MASK IN SQL LOADER [message #57465 is a reply to message #57433] |
Tue, 17 June 2003 11:35 |
sidd
Messages: 130 Registered: May 2003
|
Senior Member |
|
|
Here is how i did in my case, you have implied decimal here, so try this, it should work, let me know if not.
FieldName DECIMAL EXTERNAL(12) "DECODE(:FieldName,NULL,'',:FieldName/100)"
|
|
|