PLSQL常用函数【DOC精选】.docVIP

PL/SQL函數 2008-01-18 10:56 --【字符串函数】--字符串截取substr(字段名，起始点,个数)select Name,substr(Name,2,4),substr(Name,0,3),substr(Name,-2,3),substr(Name,-2,1) from t1; --字符串从前面取三个(0开始)select Name,substr(Name,0,3) from t1;--字符串从后面取三个select Name,substr(Name,-3,3),length(Name) 串 from t1; SELECT ASCII(A),ASCII(B) from dual; select CHR(100),CHR(80) from dual; select CONCAT(CHR(65),CONCAT(CHR(67),CHR(98))) from dual; select CHR(65)||CHR(66)||CHR(76) from dual; --将每个。select INITCAP(substr,abc,substring) from dual;--返回i在MISSISSIPPI中第3次出select INSTR(Mississippi,i,5,3) from dual;select INSTR(Mississippi,i,-2,3)