Convert string to a number and then adds 25 5 to that number
SQL> SQL> -- Convert string to a number and then adds 25.5 to that number: SQL> SQL> SELECT TO_NUMBER('970.13') + 25.5 FROM dual; TO_NUMBER('970.13')+25.5 ------------------------ 995.63 SQL> SQL>