How do I know the number of decimal places for type NUMBER (12, 2) in an Oracle database?
V_FATURA NUMBER(12, 2)
How do I know the number of decimal places for type NUMBER (12, 2) in an Oracle database?
V_FATURA NUMBER(12, 2)
The type NUMBER
in Oracle has the following syntax:
NUMBER [(precision [ scale])]
Where precision defines how many "characters" your number will have and the scale defines how many decimal places.
For example:
NUMBER (12,2)
Accept up to% number of%
Source: link