Rtrim removes a set of characters from the right of a string : RTRIM « Character String Functions « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. Character String Functions
  3. RTRIM

RTRIM stands for "right trim."

The general format for this function is:

RTRIM(string, characters_to_remove)

SQL> SELECT RTRIM('Computers', 's') FROM dual;

RTRIM('C
--------
Computer

SQL>








11.14.RTRIM
11.14.1.RTRIM(x [, trim_string]) trim characters from the right of x.
11.14.2.Rtrim removes a set of characters from the right of a string
11.14.3.Trim letter S from both sides