Convert string to a number and then adds 25.5 to that number : TO_NUMBER « Data Type « Oracle PL / SQL






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>
           
       








Related examples in the same category

1.Convert the string to a number and pass the format string $99,999.99 to TO_NUMBER()
2.Converts the string 970.13 to a number using TO_NUMBER()
3.use to_number to convert char to number