3

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

IAdapter
  • 62,595
  • 73
  • 179
  • 242
Josh Kodroff
  • 27,301
  • 27
  • 95
  • 148

1 Answers1

5

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
  • 4,262
  • 2
  • 33
  • 38