Conversion Functions Oracle PLSQL Tutorial

  1. Home
  2. Oracle PLSQL Tutorial
  3. Conversion Functions
  4. Converts the string -$12,345 67 to a number, passing the format string $99,999 99 to TO_NUMBER()
SQL>
SQL> SELECT TO_NUMBER('-$12,345.67', '$99,999.99') FROM dual;
TO_NUMBER('-$12,345.67','$99,999.99')
-------------------------------------
                            -12345.67
SQL>