Mega Code Archive

 

Categories / Oracle PLSQL / Data Type

 

TO_CHAR(-12345 67, 99,999 99) (2)

SQL> SQL> SQL> SELECT TO_CHAR(-12345.67, '99,999.99')  FROM dual; TO_CHAR(-1 ---------- -12,345.67 SQL> SQL>