Conversion Functions Oracle PLSQL Tutorial

SQL> Select TO_CHAR(12345.67, '$99,999.99')   from dual;
TO_CHAR(123
-----------
 $12,345.67