RTRIM

RTRIM scans a text expression from right to left and removes all the characters that match the characters in the trim expression, until it finds an unmatched character.

Return Value

VARCHAR2 | CLOB

Syntax

RTRIM(char [, set ])

Arguments

char is the text expression to be trimmed.

set is a text expression with the characters to remove. The default value of set is a single blank.

Examples

RTRIM('You did that!?!?!?!', '?!') returns the value You did that.

RTRIM('3.14848', '84') returns the text value 3.1.