Question

Explain in your own words what the precision (p) and scale (s) parameters for the Oracle data type NUMBER mean.

Answer 1

Dear Student ,

As per the requirement submitted above , kindly find the below solution.

Oracle data type NUMBER :

• In oracle number data type is used to store the integer values and floating point values.
• This means if need to store age of a person then number is used because age is represented with integer values such as 12,36,42 etc.
• But if there is requirement to store mobile number of a person then number(10) can be used.
• This means phone number can contains only digits.This is called  precision (p).
• If there is requirement to store price of a product , then price might be in fraction and hence number(5,2) can be used.
• This means price can store upto 5 digits before decimal point and after decimal point there is 2 digits.
• This is called number(p,s) , here p stands for precision and s stands for scale.
• In oracle precision can be vary from 1 to 38
• and scale cab be vary from -84 to 127.

NOTE : PLEASE FEEL FREE TO PROVIDE FEEDBACK ABOUT THE SOLUTION.