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 WORD

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@]