did you know ( I didn’t ) that you can provide a star (*) when defining a number column ?
SQL> create table t1 ( a number(*), b number(*,10) ); Table created. SQL> desc t1; Name Null? Type ----------- -------- ---------------------------- A NUMBER B NUMBER(38,10)