Is it possible to declare column which has the number data type and its scale larger than the precision? For example defining columns like: column name NUMBER (10,100), column name NUMBER (10,-84)

Is it possible to declare column which has the number data type and it

1.	Is it possible to declare column which has the number data type and its scale larger than the precision? For example defining columns like: column name NUMBER (10,100), column name NUMBER (10,-84)
Answer» Yes, these type of declarations are POSSIBLE. Number (9, 12) INDICATES that there are 12 DIGITS after DECIMAL POINT. But since the maximum precision is 9, the rest are 0 padded like 0.000999999999. Number (9, -12) indicates there are 21 digits before the decimal point and out of that there are 9 possible digits and the rest are 0 padded like 999999999000000000000.0