Introduction SQL

Basic SQL

SQL Constraints

Advance SQL

SQL Joins

SQL Function


SQL TRIM Function - SQL LTRIM, RTRIM Function


SQL TRIM Function

SQL TRIM function remove all specified trim char from beginning and ending of the string.

Supported Oracle SQL Version :

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

Syntax :

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

Parameters :

  • LEADING remove trim_character from beginning of the string.
  • TRAILING remove trim_character from ending of the string.
  • BOTH remove trim_character from both beginning and ending of the string.
  • trim_character specified the trim character that you want to remove from the string. If you not specify TRIM function remove spaces from string.
  • FROM is a keyword.
  • string original string that we want to trim.

Example :

Consider following example how to TRIM function remove specified character.

SQL> SELECT TRIM(LEADING 'N' FROM 'NOpal Kole') "LEADING TRIM" FROM DUAL;

LEADING TRIM
------------
   Opal Kole

SQL LTRIM Function

SQL LTRIM function remove all specified trim char from left side of the string.

Supported Oracle SQL Version :

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

Syntax :

LTRIM(string, trim_char)

Parameters :

  • string is string that string you want to trim from left side.
  • trim_char is specified char that character you want remove from the string.

Example :

Consider following example remove all specified trim char from left side of the given string argument.

SQL> SELECT LTRIM('2254Opal Kole', '2254') "LTRIM" FROM DUAL;

LTRIM
---------
Opal Kole

SQL RTRIM Function

SQL RTRIM function remove all specified trim char from right side of the string.

Supported Oracle SQL Version :

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

Syntax :

RTRIM(string, trim_char)

Parameters :

  • string is original string.
  • trim_char is specified char that character you want remove from the string.

Example :

Consider following example remove all specified trim char from right side of the given string argument.

SQL> SELECT RTRIM('Opal Kole2254', '2254') "RTRIM" FROM DUAL;

RTRIM
---------
Opal Kole