Oracle PL/SQL To_Number Function

The To_Number function converts a string to a number.

The To_Number Function syntax:

to_number( string, [ format_mask ], [ nls_language ] )

Example

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

2199.89


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

345