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>