Friday, January 11, 2013

Trim Function


In Oracle/PLSQL, the trim function removes all specified characters either from the beginning or the ending of a string.

Syntax

The syntax for the trim function is:
trim( [ leading | trailing | both [ trim_character ] string1 )
leading - remove trim_string from the front of string1.
trailing - remove trim_string from the end of string1.
both - remove trim_string from the front and end of string1.
trim_character is the character that will be removed from string1. If this parameter is omitted, the trim function will remove all leading and trailing spaces from string1.
string1 is the string to trim.

Note

If you do not choose a value for the first parameter (leadingtrailingboth), the trim function will remove trim_string from both the front and end of string1.

Applies To

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

For Example

trim('   tech   ')would return 'tech'
trim(' '  from  '   tech   ')would return 'tech'
trim(leading '0' from '000123')would return '123'
trim(trailing '1' from 'Tech1')would return 'Tech'
trim(both '1' from '123Tech111')would return '23Tech'