Thread: Numeric Data

I created a table for testing purpose
create table xx (a number)

inserting 38 digit number
insert into xx values(11111111111111111111111111111111111111)

inserting 39 digit number
insert into xx values(111111111111111111111111111111111111111)

inserting 126 digit number
insert into xx values(1111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111)

if i try to insert 127 digit number then it is showing message ora - 01426 numeric overflow.

Precision for oracle numeric data is 38 only. How it is accepting a numeric value upto 126 digits?