How can an Oracle NUMBER have a Scale larger than the Precision?
Posted
by aiGuru
on Stack Overflow
See other posts from Stack Overflow
or by aiGuru
Published on 2010-03-18T21:30:29Z
Indexed on
2010/03/18
21:31 UTC
Read the original article
Hit count: 314
The documentation states: "Precision can range from 1 to 38. Scale can range from -84 to 127".
How can the scale be larger than the precision? For example I can't create a column with the datatype NUMBER(10, 100)
. Shouldn't the Scale range from -38 to 38?
© Stack Overflow or respective owner