number datatype

From: Mei <hmpeng_at_ppserver.tamu.edu>
Date: Mon, 13 Mar 2000 14:59:18 -0600
Message-ID: <8ajkug$cam$1@news.tamu.edu>

Hello,

I want to create a table that has "number" as one of the datatype. The numbers that I have are from 0 to 1e-100. The numbers less than 0.001 are expressed in scientific notation such as 1e-40. The numbers that more than 0.001 are expressed in floating point.

If I don't set precision and scale, I will see 1e-40 become 1.0000E-40 in sqlplus. If I spool the result out to a file, then it become

.0000000000000000000000000000000000E-40.

My question is how do I set the precision and scale for this type of data. Or can I format the data in a way that does not show so many 0.

Any help will be greatly appreciated.

Thanks,

Mei Received on Mon Mar 13 2000 - 14:59:18 CST