To_Number Function Examples

Example To_Number select

select to_number('3499.79', '9999.99') from dual;
Result: '3499.79'
select to_number('754', '999') from dual;
Result: '754'