字段处理rtrim去掉结尾的特殊字符和空格

SQL> create table ycrtest2 (name varchar2(50));


Table created.


SQL> insert into ycrtest2 values('ABC       @@');


1 row created.


SQL> insert into ycrtest2 values('AB C      @@@');


1 row created.


SQL> commit;


Commit complete.


SQL> 
SQL> 
SQL> SELECT rtrim(rtrim('AB C       @@', '@'), ' ') rtrim_result FROM dual;


RTRI
----
AB C

SQL> SELECT rtrim(rtrim(name, '@'), ' ') rtrim_result FROM ycrtest2;


RTRIM_RESULT
--------------------------------------------------
ABC
AB C

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

转载于:http://blog.itpub.net/29135257/viewspace-2122622/