The Oracle and PL/SQL TO_NUMBER function converts a string to a number.
The general format is:
TO_NUMBER(char [,fmt])
Example 1:
SELECT TO_NUMBER('123') FROM DUAL;
returns:
123
Example 2:
SELECT TO_NUMBER('123.45',''9999.99'') FROM DUAL;
returns:
123.45