Mega Code Archive

 

Categories / Oracle PLSQL / Data Type

 

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>