keep leading zeros in a number field

[Shestakov]

SQL> select to_char(123, '099999') from dual;

TO_CHAR
-------
000123

SQL> col a format 0999999;
SQL> select 123 a from dual;

A
--------
0000123