DB version:11.2.0.4
I always advise application developers to use NUMBER data type if you are going to store number in that column.
But, I have a requirement to store numbers starting with 0. I just discovered that oracle trims/removes any 'number' that starts with a zero .
Changing the column data type to VARCHAR2 will work. So, is this standard workaround when you want to store numbers starting with zero ?
SQL> create table t1 (col1 number);
Table created.
SQL> insert into t1 values (0383838);
1 row created.
SQL> commit;
Commit complete.
SQL> select * from t1;
COL1
----------
383838