单元十一：数据类型的显式转换TOCHAR用于数值型(1)完美版资料.pptx

#,TO_CHAR,用于数值型,目录,2,TO_CHAR,用于数值型,TO_CHAR(number,fmt),TO_CHAR用于数值型,TO_CHAR用于数值型,TO_CHAR用于数值型,2 FROMemp,TO_CHAR(number,fmt),TO_CHAR用于数值型,2 FROMemp,TO_CHAR用于数值型,TO_CHAR用于数值型,TO_CHAR用于数值型,TO_CHAR用于数值型,TO_CHAR用于数值型,TO_CHAR用于数值型,SQL SELECTTO_CHAR(sal,$99,999)SALARY,TO_CHAR,用于数值型,3,通过在,TO_CHAR,中使用以下形式可以把数值型数据转化成变长的字符串：,TO_CHAR(,number,fmt,),9,0,$,L,.,一位数字,显示前导零,显示美元符号,显示本地货币号,显示小数点,显示千位符,TO_CHAR用于数值型,TO_CHAR用于数值型,TO_CHAR用于数值型,TO_CHAR用于数值型,SQL SELECTTO_CHAR(sal,$99,999)SALARY,TO_CHAR用于数值型,SQL SELECTTO_CHAR(sal,$99,999)SALARY,TO_CHAR(number,fmt),SQL SELECTTO_CHAR(sal,$99,999)SALARY,SQL SELECTTO_CHAR(sal,$99,999)SALARY,SQL SELECTTO_CHAR(sal,$99,999)SALARY,SQL SELECTTO_CHAR(sal,$99,999)SALARY,SQL SELECTTO_CHAR(sal,$99,999)SALARY,通过在TO_CHAR中使用以下形式可以把数值型数据转化成变长的字符串：,TO_CHAR用于数值型,TO_CHAR用于数值型,TO_CHAR,用于数值型,4,SQL SELECTTO_CHAR(sal,$99,999)SALARY,2 FROMemp,3 WHEREename=SCOTT;,SALARY,-,$3,000,Thanks,