So, I was looking through the documentation to see what the difference between NUMBER and INTEGER was, and I came across this def'n of NUMBER which confuses me:
NUMBER(p,s) Number having precision p and scale s. The precision p
can range from 1 to 38. The scale s can range from -84 to 127.
How could you ever store a value like
NUMBER (38,127)
If 38 is the max for precision, then NUMBER(38,38) should be the limit. I can define a NUMBER (38,127) - meaning Oracle doesn't throw an error, but I don't know what that means. And I can't seem to insert any values
SQL> create table t (f number(38,127));
Table created.
SQL> insert into t values (1);
insert into t values (1)
*
ERROR at line 1:
ORA-01438: value larger than specified precision allows for this column
SQL> insert into t values (.1);
insert into t values (.1)
*
ERROR at line 1:
ORA-01438: value larger than specified precision allows for this column
---=Chuck