Skip Headers
Oracle® OLAP DML Reference
10g Release 2 (10.2)

Part Number B14346-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
Go to next page
Next
View PDF

TRIM

The TRIM function enables you to trim leading or trailing characters (or both) from a character string.

You can also trim leading characters using LTRIM and trailing characters using RTRIM.

Return Value

The data type of the string you are trimming (that is, trim-source).

Syntax

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

Arguments

trim-character

An expression that specifies the values to be trimmed. This text expression can be any of the text data types. When you do not specify a value, then the default value is a blank space and the function removes leading and trailing blank spaces.

LEADING

Specifies that the function removes any leading characters equal to trim_character.

TRAILING

Specifies that the function removes any trailing characters equal to trim_character.

BOTH

Specifies that the function removes leading and trailing characters equal to trim_character.

trim-source

An expression that is the value to be trimmed. This text expression can be any of the text data types.