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'