i need store number around 2147483647 in oracle table.
what oracle table field can recommend suitable number?
from oracle doc
number datatype number datatype stores fixed , floating-point numbers. numbers of virtually magnitude can stored , guaranteed portable among different systems operating oracle database, 38 digits of precision.
the following numbers can stored in number column:
positive numbers in range 1 x 10-130 9.99...9 x 10125 38 significant digits
https://docs.oracle.com/cd/b28359_01/server.111/b28318/datatype.htm#i16209
Comments
Post a Comment