Storing trailing zeros in mantissa

I have a column defined as NUMBER(18,2) and want to store a value of, say, "10.20" in this column. Oracle returns the value to me as "10.2" instead of "10.20", but in my application (scientific in nature) there is a difference in "10.2" and "10.20".

After browsing the ng's, it seems this is normal behavior in Oracle... Is this true? Does anyone know any magical "switches" I can flip to tell Oracle to store trailing zeros?

Thanks,
Jeff Received on Fri Aug 01 2003 - 09:04:16 CDT