sql tonumber 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] )