Mega Code Archive

 

Categories / Oracle PLSQL / Data Type

 

TO_CHAR(0012345 6700, FM99999 99)

SQL> SQL> SQL> SELECT TO_CHAR(0012345.6700, 'FM99999.99') FROM dual; TO_CHAR(0 --------- 12345.67 SQL>