to_number in oracle code example
Example 1: oracle to_number
TO_NUMBER('1210.73', '9999.99')
Result: 1210.73
TO_NUMBER('546', '999')
Result: 546
TO_NUMBER('23', '99')
Result: 23
Example 2: oracle to_number
TO_NUMBER( string1 [, format_mask] [, nls_language] )