Data Type Oracle PLSQL

  1. Home
  2. Oracle PLSQL
  3. Data Type
  4. 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>