[Oracle]RTRIM()

오라클 RTRIM()

 

RTRIM()

   -

 

RTRIM(char, set)

의 형태

 

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 sililarly to LTRIM.

 

Both char and set can be any of the data types CHAR, VARCHAR2, NCHAR, NVARCHAR2, CLOB or NCLOB. The string returned os of VARCHAR2 data type if char is a character data type, NVARCHAR2 if char is a national character data type, and a LOB if char is a LOB data type.

 

SQL> SELECT RTRIM('<=====>BROWING<======>', '<>=') FROM DUAL;
   ---> <=====>BROWING

SQL> SELECT RTRIM('<=====>BROWING<======>', '>') FROM DUAL;
   ---> <=====>BROWING<======

SQL> SELECT RTRIM('ABCDEF', '') FROM DUAL;

   ---> 

SQL> SELECT RTRIM('ABCDEF', 'F') FROM DUAL;

   ---> ABCDE