Oracle 中数字格式的最大值是多少？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/3467258/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
What is the maximum of the number-format in Oracle?
提问by Husky110
I want to know what is the maximum value the number-format? For example int32 can handle 4.294.967.296 values.
我想知道数字格式的最大值是多少？例如 int32 可以处理 4.294.967.296 个值。
回答by Sachin Shanbhag
Based on this Oracle's documentation:
基于此 Oracle 文档：
The NUMBER datatype stores fixed and floating-point numbers. Numbers of virtually any magnitude can be stored and are guaranteed portable among different systems operating Oracle, up to 38 digits of precision.
The following numbers can be stored in a NUMBER column:
- Positive numbers in the range 1 x 10-130 to 9.99..9 x 10125 with up to 38 significant digits
- Negative numbers from -1 x 10-130 to 9.99..99 x 10125 with up to 38 significant digits
- Zero
- Positive and negative infinity (generated only by importing from an Oracle Version 5 database)
NUMBER 数据类型存储定点数和浮点数。可以存储几乎任何数量级的数字，并保证在运行 Oracle 的不同系统之间可移植，精度高达 38 位。
以下数字可以存储在 NUMBER 列中：
- 1 x 10-130 到 9.99..9 x 10125 范围内的正数，最多 38 位有效数字
- 从 -1 x 10-130 到 9.99..99 x 10125 的负数，最多 38 位有效数字
- 零
- 正无穷大和负无穷大（仅通过从 Oracle 版本 5 数据库导入生成）
There's also this other documentationwhich summarizes very well the types and precision for numeric and other data types as well.
还有这个其他文档，它很好地总结了数字和其他数据类型的类型和精度。
