Converts the string 970.13 to a number using TO_NUMBER()
SQL>
SQL> ---------------------------------------------------------------------------------------
SQL>
SQL> -- Converts the string 970.13 to a number using TO_NUMBER():
SQL>
SQL> SELECT TO_NUMBER('970.13') FROM dual;
TO_NUMBER('970.13')
-------------------
970.13
SQL>