to_number

Converts "string_expression1" to a numeric value as specified by the format "string_expression2". "String_expression3" specifies the format elements, such as currency information.

to_number ( string_expression1 , string_expression2 ,
 string_expression3 )