RTRIM(x [, trim_string]) trim characters from the right of x. : RTRIM « Character String Functions « Oracle PL/SQL Tutorial






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

You can supply an optional trim_string that specifies the characters to trim.

If no trim_string is supplied, spaces are trimmed by default.

SQL> SELECT RTRIM('Hi abcabc', 'abc') FROM dual;

RTR
---
Hi

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