What is the number of decimal places of type NUMBER (12,2)?

1

How do I know the number of decimal places for type NUMBER (12, 2) in an Oracle database?

V_FATURA NUMBER(12, 2)
    
asked by anonymous 01.06.2018 / 16:28

1 answer

5

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

    
01.06.2018 / 16:52