Question

List datatypes available in numeric data types

Answer 1

Answer:

The exact numeric types are INTEGER , BIGINT , DECIMAL , NUMERIC , NUMBER , and MONEY . Approximate numeric types, values where the precision needs to be preserved and the scale can be floating. The approximate numeric types are DOUBLE PRECISION , FLOAT , and REAL

Answer 2

INTEGER, FLOAT, LONGINT, BYTE, DOUBLE are the precise numeric kinds.

List datatypes available in numeric data types :

• Numbers are stored in database columns as numeric data types. Exact numeric types, values where accuracy and scale must be retained are examples of these data types.
• INTEGER
• FLOAT
• LONGINT
• BYTE
• DOUBLE is the precise numeric kind.

• Integer and decimal data types are examples of exact data types. Floating-point data types are examples of approximate data types.