Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Character String Functions

 

RTRIM(x [, trim_string]) trim characters from the right of x

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>