NUMBER is a numeric data type that can optionally have a precision and scale specified at creation.
The precision can range from 1 to 38 and the scale from -84 to 127.
You may also like
The sequence keywords CURVAL and NEXTVAL can’t be used in: the condition of a CHECK constraint the DEFAULT value of a table column […]
It is an interesting example that deserves to be considered since it is a guaranteed case on your exam. Let’s consider a […]
Can LONG columns be used in queries joined by set operators? The UNION, INTERSECT, and MINUS operators are not valid on LONG […]
This is Oracle 12c feature. Prior to 12c, the DEFAULT for a column would not be applied if you explicitly (or implicitly) inserted a […]