Conversion Functions Oracle PLSQL Tutorial

  1. Home
  2. Oracle PLSQL Tutorial
  3. Conversion Functions
  4. TO_CHAR(12345 67, C99,999 99)
SQL> Select TO_CHAR(12345.67, 'C99,999.99')   from dual;
TO_CHAR(12345.67,
-----------------
     USD12,345.67