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.
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'