ORACLE/PLSQL: TRIM FUNCTION

This Oracle tutorial explains how to use the Oracle/PLSQL TRIM function with syntax and examples.

DESCRIPTION

The Oracle/PLSQL TRIM function removes all specified characters either from the beginning or the ending of a string.

SYNTAX

The syntax for the TRIM function in Oracle/PLSQL is:

TRIM( [ [ LEADING | TRAILING | BOTH ] trim_character FROM ] string1 )

Parameters or Arguments

LEADING

The function will remove trim_character from the front of string1.

TRAILING

The function will remove trim_character from the end of string1.

BOTH

The function will remove trim_character from the front and end of string1.

trim_character

The character that will be removed from string1. If this parameter is omitted, the TRIM function will remove space characters fromstring1.

string1

The string to trim.

Note:

If you do not choose a value for the first parameter (LEADING, TRAILING, BOTH), the TRIM function will removetrim_character from both the front and end of string1.

APPLIES TO

The TRIM function can be used in the following versions of Oracle/PLSQL:

• Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i, Oracle 8i

EXAMPLE

Let's look at some Oracle TRIM function examples and explore how to use the TRIM function in Oracle/PLSQL.

For example:

TRIM('   tech   ')
Result: 'tech'

TRIM(' '  FROM  '   tech   ')
Result: 'tech'

TRIM(LEADING '0' FROM '000123')
Result: '123'

TRIM(TRAILING '1' FROM 'Tech1')
Result: 'Tech'

TRIM(BOTH '1' FROM '123Tech111')
Result: '23Tech'

Share on Google Plus

About Mindsforest