select rtrim('ligaoyuanlishunxing','lishunxing') from dual;
为啥结果是ligaoyua
rtrim(c1,c2)--从c1中去除c2(只去除尾部开始第一个字符c2)如:select rtrim('ababa','a') from dual;结果:abab