Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> number datatype

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US