Check out the online Oracle doc :
p is the precision or maximum number of significant decimal places of the digit, where the most significant digit is the leftmost nonzero value of the digit, and the smallest significant digit is the most famous digit. Oracle guarantees number portability with an accuracy of 20 basic 100 digits, equivalent to 39 or 40 decimal places, depending on the position of the decimal point.
s is the scale or number of digits from the decimal point to the least significant digit. The scale can vary from -84 to 127.
A positive scale is the number of significant digits to the right of the decimal point with the smallest significant digit.
A negative scale is the number of significant digits to the left of the decimal point, but not including the least significant digit. For a negative scale, the smallest significant digit is on the left side of the decimal point, since the actual data is rounded to the indicated number of places to the left of the decimal point. For example, specification (10, -2) means rounding to hundreds.
Glenn source share