select substr('abcd',2,2) value from dual --取字串
SELECT replace('abcdefbcd', 'bcd', '你') value from dual --替换字符串
select Translate('fasdbfasegas','fa','我' ) value from dual
select INITCAP('abcd dsaf df') value from dual --首字母大写
select LPAD('abcd',14) value from dual --左补空格
select RPAD('abcd',14) value from dual --右补空格
select CONCAT('11','22')||33 value from dual-- 连接字符串
select ascii('b') value from dual --转换ascii码
select greatest(1,-2,4,3) value from dual --求最大值