Paste this into a new question or an answer at dba.stackexchange.com:
<!-- --> > select * from v$version; > > <pre> > | BANNER | > | :------------------------------------------------------------------------ | > | Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production | > | PL/SQL Release 11.2.0.2.0 - Production | > | CORE 11.2.0.2.0 Production | > | TNS for Linux: Version 11.2.0.2.0 - Production | > | NLSRTL Version 11.2.0.2.0 - Production | > </pre> <!-- --> > create table t42 (column1 numeric(30,20)); > > <pre> > ✓ > </pre> <!-- --> > insert into t42 (column1) values (9999999999.10390625); > > <pre> 1 rows affected > </pre> <!-- --> > insert into t42 (column1) values (0.10390625); > > <pre> 1 rows affected > </pre> <!-- --> > select * from t42; > > <pre> > | COLUMN1 | > | ------------------: | > | 9999999999.10390625 | > | .10390625 | > </pre> *db<>fiddle [here](https://dbfiddle.uk/?rdbms=oracle_11.2&fiddle=5e8b8ef6843e8235d51405cc38e015f0)*
back to fiddle