create table test(f number(16,2));
insert into test values(99999999999999.99);

------解决方案--------------------
不是表的问题
SQL code
select 99999999999999.99 as f1,9999999999999.99 as f2 from dual
/*
F1    F2
100000000000000    9999999999999.99
*/