Mega Code Archive

 

Categories / Oracle PLSQL / Data Type

 

TO_CHAR(12345 67, U99,999 99)

SQL> SQL> SQL> SELECT TO_CHAR(12345.67, 'U99,999.99') FROM dual; TO_CHAR(12345.67,'U9 --------------------           $12,345.67 SQL>