CODEWITHSUNDEEP
sqloracle-databaseoracle11goracle12csqldatatypes
Shubham Sharan
Shubham Sharan

Reputation: 23

Number format issue in Oracle

So i have created a test table having a number column which is of the data type Number(11,8). Now when i am trying to insert the value 13332 in the table it is throwing an oracle error saying:

ORA-01438: value larger than specified precision allowed for this column

I am not sure why. The same works when i am inserting into a column with data type Number(12,6)

INSERT INTO MY_TABLE(COLUMN_1)
values('13332');

Upvotes: 0

Views: 126

Answers (1)

Somy
Somy

Reputation: 1624

The reason is - out of 11 digits you have specified 8 digits after decimal places so for the whole number part (before the decimal) you are allowed only 3 digits.

Assuming you want to reserve 8 digits post decimal place in your case it would work if you define the data type as number(13,5) which would allow 5 digits for the whole number.

Upvotes: 3

Related Questions