Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Conversion Functions

 

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>