PL/SQL Rtrim

Oracle PL/SQL Rtrim Function

The Rtrim function removes all specified characters from the right-hand side of a string.

The Rtrim Function syntax:

rtrim( string, [ trim_text ] )

String is the string to trim the characters from the right-hand side.

Trim_text is the string that will be removed from the right-hand side of string.

Example

select rtrim('oracle  ') from dual; 

would return 'oracle'


select rtrim('database86000', '0') from dual;

would return 'database86'


select rtrim('098Java098', '098') from dual;

would return '098Java'


select rtrim('Formsxyzzxyxy', 'xyz') from dual;

would return 'Forms'


select rtrim('Website7658923140', '0123456789') from dual;

would return 'Website'