1.SUBSTR(cExpression,nStartPosition
[,nCharactersReturned])
取子字符串,从nStartPosition开始, 取nCharactersReturned个(缺省时返回字符表达式的值结束前的全部字符)
select substr('13 0123456789', 3) from dual;--返回0123456789
select substr('13 0123456789', 3,5) from dual;--返回01234
2.Replace(old_text,old_chars,new_chars)
select replace('he love you','he','') from dual;--删除已有字符串he
select replace('he love you','he','i') from dual;--返回i love you
取子字符串,从nStartPosition开始, 取nCharactersReturned个(缺省时返回字符表达式的值结束前的全部字符)
select substr('13 0123456789', 3) from dual;--返回0123456789
select substr('13 0123456789', 3,5) from dual;--返回01234
2.Replace(old_text,old_chars,new_chars)
select replace('he love you','he','') from dual;--删除已有字符串he
select replace('he love you','he','i') from dual;--返回i love you