TRIM

Syntax

trim::=

Text description of trim

Purpose

TRIM enables you to trim leading or trailing characters (or both) from a character string. If trim_character or trim_source is a character literal, you must enclose it in single quotes.

• If you specify LEADING, Oracle removes any leading characters equal to trim_character.

• If you specify TRAILING, Oracle removes any trailing characters equal to trim_character.

• If you specify BOTH or none of the three, Oracle removes leading and trailing characters equal to trim_character.

• If you do not specify trim_character, the default value is a blank space.

• If you specify only trim_source, Oracle removes leading and trailing blank spaces.

• The function returns a value with datatype VARCHAR2. The maximum length of the value is the length of trim_source.

• If either trim_source or trim_character is a null value, then the TRIM function returns a null value.

Both trim_character and trim_source 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 trim_source.

Example

This example trims leading and trailing zeroes from a number:

SELECT TRIM (0 FROM 0009872348900) "TRIM Example"
   FROM DUAL;

TRIM example
------------
    98723489