database - How much range Oracle Number(18) can store? -
i looking @ documentation number type in oracle db can store range 10 raise -130 10 raise 126.
was wondering how many positive numbers field number(18) can store?
integer numbers 18 digits (integers between -10^18+1
, 10^18-1
)
according oracle documentation, number
datatype stores fixed , floating-point numbers. optionally, can specify precision (total number of digits) , scale (number of digits right of decimal point):
number (precision, scale)
if no scale specified, scale zero.
in case, number(18)
, specified precision
of 18 digits , did not specify scale
0
used (no numbers after decimal point).
Comments
Post a Comment