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