Is there a simple formula for determining the maximum and minimum values for an Oracle NUMBER column with (p, s)?
views:
514answers:
1
+3
A:
I'm not sure, it is something like:
from - 10 ** (p - s) to 10 ** (p - s)
p is number of significant decimal digits, and s is number of digits after period. So
NUMBER(6, 2)
can store values from -9999.99 to +9999.99.
stepancheg
2009-05-08 19:34:34