Jan 15, 2016 · 1 Answer 1 ... NUMBER(12,0) indicates a numeric data type with precision 12 and scale 0 . A related SO post explains precision and scale further:.
People also ask
What is datatype number 12 0 in Oracle?
NUMBER(12,0) indicates a numeric data type with precision 12 and scale 0 . A related SO post explains precision and scale further: Precision is the number of significant digits. Oracle guarantees the portability of numbers with precision ranging from 1 to 38.
Jan 15, 2016
What is numeric 12 in SQL?
Numeric (12,7) means that the 12 is the precision of the data i.e. it specifies the maximum total number of decimal digits that can be stored, both to the left and to the right of the decimal point. The precision must be a value from 1 through the maximum precision. The maximum precision is 38.