Numeric Format in SQL

[Shestakov]

SQL> col a format '09999.999'
SQL> select 987.76 a from dual;

A
----------
00987.760

SQL> col a format '099,999.999'
SQL> select 987.76 a from dual;

A
------------
000,987.760