The largest value the can be stored in an Oracle NUMBER column is 9.999999999999999999999999999999999999999e+125 (or 40 9's followed by 66 0's). If you use more digits (and thus larger values) in INSERT and UPDATE statements they will either be rounded down (silently) to this value or return an ORA-01426 (numeric overflow) error.

If I have a column of NUMBER data type, what is the largest number that can be stored in this column?