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

Asked

Viewed 3,357 times

1

How to know the number of decimals for type NUMBER(12, 2) in an Oracle database ?

V_FATURA NUMBER(12, 2)
sql oracle pl-sql
  • 5

    Ué, is 2. Accuracy is 12.2

  • Is that the question? Do you have any extra reason to ask such an obvious question?

  • Thinking of something other than the obvious, perhaps the question relates to the number of decimals.. ex: 1.11 would have "precision" of two; 1.10, of a; and 1.00, zero.. would that be it??

  • In a software in which I am performing maintenance, I received an error message related to the type number(12,2) but I was not aware of the concept of the data type in the oracle. I thank you all shared your knowledge with me.

1 answer

4


The guy NUMBER in Oracle has the following syntax:

NUMBER[(accuracy [, scale])]

Where precision defines how many "characters" your number will have and scale defines how many decimal places.

For example:

NUMBER(12,2)

He’ll take the number 9999999999,99

Source: http://www.orafaq.com/wiki/Number

Browser other questions tagged sql oracle pl-sql

You are not signed in. Login or sign up in order to post.