Number Data Type

1.     NUMBER is used to store numeric values in Oracle.

2.     Can store integers, decimals, and floating-point numbers.

3.     Supports optional precision (total digits) and scale (digits after the decimal).

4.     Syntax: NUMBER(p,s) where p is precision and s is scale.

5.     Maximum precision is 38 digits.

6.     If precision and scale are omitted, it can store any valid number.

7.     Can store positive and negative values.

8.     Used for arithmetic operations in SQL and PL/SQL.

9.     Takes variable storage depending on the value.

10.  Ideal for storing IDs, amounts, counts, or calculations.