ltrim and rtrim函数使用例子

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 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博客 ” ，链接：http://blog.itpub.net/36779/viewspace-890004/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/36779/viewspace-890004/