SQL RTRIM

This will trim off unwanted characters from the right end of string.

     Syntax: rtrim (string [, unwanted_chars])

     Ex:

          SQL> select rtrim('computer','er'), rtrim('computer','ter') from dual;

RTRIM(  RTRIM

--------  ---------

comput   compu

SQL> select rtrim('computer','comput’), rtrim('computer','compute') from dual;

RTRIM('C  RTRIM('C

----------   ----------

computer   computer

           -- If you haven’t specify any unwanted characters it will display entire string.