1
How to know the number of decimals for type NUMBER(12, 2) in an Oracle database ?
V_FATURA NUMBER(12, 2)
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
Browser other questions tagged sql oracle pl-sql
You are not signed in. Login or sign up in order to post.
Ué, is 2. Accuracy is 12.2
– Sorack
Is that the question? Do you have any extra reason to ask such an obvious question?
– Maniero
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??
– rLinhares
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.
– alexjosesilva