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






  1. Oracle PL / SQL
  2. Char Functions
  3. RTRIM

Rtrim: removes a set of characters from the right of a string


SQL> -- RTRIM stands for "right trim."
SQL> -- The general format for this function is:
SQL>
SQL> -- RTRIM(string, characters_to_remove)
SQL>
SQL>
SQL> SELECT RTRIM('Computers', 's') FROM dual;

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








Related examples in the same category

1.RTRIM function removes trailing characters
2.Use rtim to remove space
3.Rtrim char type column data