Convert the string to a number and pass the format string $99,999.99 to TO_NUMBER() : TO_NUMBER « Data Type « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Data Type
  3. TO_NUMBER

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>








Related examples in the same category

1.Convert string to a number and then adds 25.5 to that number
2.Converts the string 970.13 to a number using TO_NUMBER()
3.use to_number to convert char to number