/*cast将一种类型转换为另一种类型（可转的情况）*/
select cast('11.36' as number(10,1)) as result from dual;
/*11.4,带四舍五入特点*/
select cast('11.36' as number(10,2)) as result from dual;
/*11.36*/
select cast('11.36' as number(10,4)) as result from dual;
/*11.36*/
select cast('11.36' as char(3)) as result from dual;
/*11. */
