Oracle® Database SQL Reference 10g Release 2 (10.2) Part Number B14200-01 |
|
|
View PDF |
Syntax
Purpose
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 if char
is a character datatype and a LOB if char
is a LOB datatype.
Examples
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: