views:

514

answers:

1

Is there a simple formula for determining the maximum and minimum values for an Oracle NUMBER column with (p, s)?

+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