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---HiSQL>