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






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