oracle去掉结尾空格,字段处理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/，如需转载，请注明出处，否则将追究法律责任。