(1)
Select To_char (123.56, ' 999.9 ') from dual; would return 123.6
Select To_number (' 123.56 ', ' 999.9 ') from dual; Would fail because of error "ora-01722:invalid number"
(2)
Select To_char (123.56, ' 999 ') from dual; would return 124
Select To_number (123.56, ' 999 ') from dual; Would fail because of error "ora-01722:invalid number"
(3)
Select To_char (123.56, ' 9999.99 ') from Dual;will return 123.56
Select To_number (' 123.56 ', ' 9999.99 ') from dual; would return 123.56
(4)
Select To_char (123.56, ' 9999 ') from dual; would return 124
Select To_number (' 123.56 ', ' 9999 ') from dual; Would fail because of error "ora-01722:invalid number"
(5)
Select To_char (123.56, ' the ") from dual; Would return # # #
Select To_number (123.56, ' the ") from dual; Would fail because of error "ora-01722:invalid number"
(6)
Select To_char (123.56, ' 999.99 ') from dual; would return 123.56
Select To_number (123.56, ' 999.99 ') from dual; would return 123.56
Oracle Sql:to_char and To_number notes
