Data Type Oracle PLSQL

  1. Home
  2. Oracle PLSQL
  3. Data Type
  4. Convert the string to a number and pass the format string $99,999 99 to TO_NUMBER()
SQL>
SQL> -- Convert the string to a number and pass 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>
SQL>
SQL>