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
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博客 ” ，链接：https://blog.itpub.net/29135257/viewspace-2122622/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
