ITPub博客

首页 > 应用开发 > IT综合 > ltrim and rtrim函数使用例子

ltrim and rtrim函数使用例子

原创 IT综合 作者:cyr1974 时间:2007-01-12 12:05:41 0 删除 编辑

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

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/36779/viewspace-890004/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2009-03-16

  • 博文量
    37
  • 访问量
    256972