PL/SQL To_Number
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