Oracle® Database SQL Reference 10g Release 1 (10.1) Part Number B10759-01 |
|
|
View PDF |
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 quotes. RTRIM
works similarly to LTRIM
.
Both char
and set
can be any of the datatypes CHAR
, VARCHAR2
, NCHAR
, NVARCHAR2
, CLOB
, or NCLOB
. The string returned is of VARCHAR2
datatype and is in the same character set as char
.
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: