ltrim and rtrim函数使用例子
select ltrim('yxxyxxxXyyacbd','xy') from dual;
LTRIM('YXXYXXXXYYACBD','XY')
Xyyacbd
select ltrim('yxxyxxxyyyacbd','xy') from dual;
LTRIM('YXXYXXXYYYACBD','XY')
select ltrim('YZZABAO','YZ') from dual;
LTRIM('YZZABAO','YZ')
ABAO
acbd
SELECT LTRIM('xyxXxyLAST WORD','xy') "LTRIM example" FROM DUAL;
LTRIM example------------XxyLAST WORDselect rtrim('yxxyxxxXyyacbd','xy') from dual;RTRIM('YXXYXXXXYYACBD','XY')
yxxyxxxXyyacbd
select rtrim('yxxyxxxyyyacbdyxxy','xy') from dual;
RTRIM('YXXYXXXYYYACBDYXXY','XY
yxxyxxxyyyacbd
select rtrim('YZZABAOYyYZ','YZ') from dual;
RTRIM('YZZABAOYYYZ','YZ')
YZZABAOYy
[@more@]
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/36779/viewspace-890004/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
项目经理所具备的素质
请登录后发表评论
登录
全部评论
