欄位處理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