marnell21
10/9/2015 - 4:02 PM

Oracle TO_NUMBER function

Convert string to numbers.

From http://docs.oracle.com/cd/E11882_01/server.112/e41084/functions211.htm#SQLRF06140

to_number.sql
content_copyfile_download
UPDATE employees SET salary = salary + 
   TO_NUMBER('100.00', '9G999D99')
   WHERE last_name = 'Perkins';

TO_NUMBER('1210.73')
Result: 1210.73