Numeric Data Types

Description

The Oracle Database numeric data types store positive and negative fixed and floating-point numbers, zero, infinity, and values that are the undefined result of an operation—"not a number" or NAN. (Oracle Language Reference Numeric Data Types)

Here are the articles in this section:

NUMBER Data TypeFLOAT Data TypeFloating-Point Numbers

Notes on arithmetic operations

Please be aware that every operation performed on numerical datatypes is internally stored as a Number. Furthermore, depending on the operation performed it is possible to incur an error related to how intermediate values are stored within Snowflake, for more information on Snowflake's post on intermediate numbers in Snowflake.