Conversion Functions Oracle PLSQL Tutorial

  1. Home
  2. Oracle PLSQL Tutorial
  3. Conversion Functions
  4. Convert the string 97 13 to a number using TO_NUMBER() and then adds 25 5 to that number
SQL>
SQL> SELECT TO_NUMBER('97.13') + 25.5 FROM dual;
TO_NUMBER('97.13')+25.5
-----------------------
                 122.63
SQL>