What does number(10,4) mean in oracle

The NUMBER(10,4) data type in Oracle stores numeric values ​​with a precision of 4 decimal places, ranging from -9999999999.9999 to 9999999999.9999. The maximum length of the integer part is 6 digits, and the maximum length of the decimal part is 4 digits.

The meaning of NUMBER(10,4) in Oracle

NUMBER(10,4) data in Oracle type is a fixed-point numeric data type used to store numeric values ​​with fixed decimal point precision.

Structure

• Overall length: 10 bytes
• Integer part length: 6 bytes
• Decimal part length: 4 bytes

Meaning

NUMBER(10 ,4) You can store numbers with values ​​ranging from -9999999999.9999 to 9999999999.9999, where:

• Integer part: Can have up to 6 integers (excluding decimal points).
• Decimal part: Can have up to 4 decimal places.

Example

• 123456.7890 is a valid NUMBER(10,4) value.
• -9876543210.1234 is a valid NUMBER(10,4) value.
• 12345678901.2345 is an invalid NUMBER(10,4) value because it exceeds the maximum length limit of the integer part.
• -12345.67890 is an invalid NUMBER(10,4) value because it exceeds the maximum length limit for the fractional part.

The above is the detailed content of What does number(10,4) mean in oracle. For more information, please follow other related articles on the PHP Chinese website!