RTRIM removes from the right end of
char all of the characters that appear in
set. This function is useful for formatting the output of a query.
If you do not specify
set, then it defaults to a single blank.
RTRIM works similarly to
set can be any of the data types
NCLOB. The string returned is of
VARCHAR2 data type if
char is a character data type,
char is a national character data type, and a LOB if
char is a LOB data type.
Appendix C in Oracle Database Globalization Support Guide for the collation determination rules, which define the collation
RTRIMuses to compare characters from
setwith characters from
char, and for the collation derivation rules, which define the collation assigned to the character return value of this function
The following example trims all the right-most occurrences of less than sign (
<), greater than sign (
>) , and equal sign (
=) from a string:
SELECT RTRIM('<=====>BROWNING<=====>', '<>=') "RTRIM Example" FROM DUAL; RTRIM Example --------------- <=====>BROWNING