Data Type Oracle PLSQL

  1. Home
  2. Oracle PLSQL
  3. Data Type
  4. TO_CHAR(12345 67, L99,999 99 )
SQL>
SQL>
SQL> SELECT TO_CHAR(12345.67, 'L99,999.99' ) FROM dual;
TO_CHAR(12345.67,'L9
--------------------
          $12,345.67
SQL>
SQL>