Oracle TO_NUMBER

The Oracle TO_NUMBER function converts expression to a value of NUMBER data type.

Oracle TO_NUMBER example

select 
to_number('3499.79', '9999.99') 
from dual;

Result: '3499.79'

select 
to_number('754', '999') 
from dual;

Result: '754'