I'm having in a NUMBER(10, 6) column the value 1E-6. I need to have the value in "regular" decimal format but can't find the conversion function.

This column stores the applyed percentage of and amount and/or a quantity. I need to transform it to have the effective amount (or quantity) based on the amount (or quantity) before the application of this percentage...

I usually have a usable formated number in that column. So. What's the magic trick to do that in a SELECT statement?

Thanks a million.