Hello Experts,
I have amount column in my table with data type number(22,2):
However it allows only values with 10 digit like below:
update XYZ.Table1
set amount=9999999999
127 rows updated.
However it does not allow below:
update XYZ.Table1
set amount=99999999999
Error report -
SQL Error: ORA-01438: value larger than specified precision allowed for this column
01438. 00000 - "value larger than specified precision allowed for this column"
*Cause: When inserting or updating records, a numeric value was entered
that exceeded the precision defined for the column.
*Action: Enter a value that complies with the numeric column's precision,
or use the MODIFY option with the ALTER TABLE command to expand
the precision.
I assumed that number(22,2) data type will allow me 22 disgit number, which does not seem to be correct.
Any idea how do precesion and lenghth work?
Thanks,
Rajneesh