Mega Code Archive

 

Categories / Oracle PLSQL / Data Type

 

TO_CHAR(12345 67, 99,999 9900)

SQL> SQL> SQL> SELECT TO_CHAR(12345.67, '99,999.9900') FROM dual; TO_CHAR(1234 ------------  12,345.6700 SQL>