To place and view values with decimal, the data type used must have precision and scale. For example: Data type , Number(p,s) p means precision and it represents the number of digits. It ranges from 1 to 38. s means scale and it represents the…