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
|
Results 1 to 7 of 7
Thread: Numeric Format in SQLThreaded View
|
Click Here to Expand Forum to Full Width |