Oracle SQL: TO_CHAR and TO_NUMBER 笔记

(6)

select TO_CHAR(123.56,'999.99') from dual; will return 123.56

select TO_NUMBER(123.56,'999.99') from dual; will return 123.56