Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQLLOADER
Look in the oracle utilities manual for numeric. You should be trying to convert the data by using "decimal external (p,s)". Precision for a packed field is (p+1)/2 rounded up. Scale is the number of digits to the right of decimal point. I hope that this helps.
Ed Mitchell
DBA
EDS
Received on Thu Feb 20 1997 - 00:00:00 CST