Oracle SQL Number or Numeric Data Type

Numeric data types are able to store numeric data either positive or negative.

 

NUMBER(Precesion)

1.It used to store numbers without decimal point.

2.Number(2) mean it can store a numeric values between 00 and 99

 

NUMBER(Precesion, [Scale])

1. It is used for values with decimal point.

2.Number(8,2) means it can store values whose after decimal points values can go up to two places 

 

•The precision is the number of digits in a number. It ranges from 1 to 38.

•The scale is the number of digits to the right of the decimal point in a number. It ranges from -84 to 127.

 

Ex:  Col_Name   number(6,2)

  ----------   -----------

  12.75

  123.1

  4562.08

  125

  0.75

Ex:  123.456--> Invalid

  0.097----> Invalid