TRIM

Purpose

This function is used to remove characters from the beginning and/or end of a string.

Syntax

TRIM([{{ LEADING | TRAILING | BOTH }[ trim_character ]|trim_character }FROM] trim_source)

Parameters

Return type

• If trim_source is of the CHAR or VARCHAR2 data type, the function returns a value of the VARCHAR2 data type.

• If trim_source is of the NCHAR or NVARCHAR2 data type, the function returns a value of the NVARCHAR2 data type.

• If trim_source is of the CLOB data type, the function returns a value of the CLOB data type.

• If trim_source or trim_character is NULL, the TRIM function returns NULL.

Examples

Remove the XX characters from the beginning and end of the string XXOceanBaseXX.

obclient> SELECT TRIM('X' FROM 'XXOceanBaseXX') "TRIM" FROM DUAL;
+-----------+
| TRIM      |
+-----------+
| OceanBase |
+-----------+
1 row in set