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. If
char is a character literal, then you must enclose it in single quotation marks.
RTRIM works similarly to
set can be any of the datatypes
NCLOB. The string returned is of
VARCHAR2 datatype if
char is a character datatype,
expr1 is a national character datatype, and a LOB if
char is a LOB datatype.
The following example trims all the right-most occurrences of period, slash, and equal sign from a string:
SELECT RTRIM('BROWNING: ./=./=./=./=./=.=','/=.') "RTRIM example" FROM DUAL; RTRIM exam ---------- BROWNING: