Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Conversion Functions

 

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>