Oracle/PLSQL: LTRIM Function
The Oracle/PLSQL LTRIM function removes all specified characters from the left-hand side of a string.
LTRIM Function Syntax
The syntax for the LTRIM function is:
LTRIM( string1, [ trim_string ] )
string1 is the string to trim the characters from the left-hand side.
trim_string is the string that will be removed from the left-hand side of string1. If this parameter is omitted, the LTRIM function will remove all leading spaces from string1.
The LTRIM function can be used in the following versions of Oracle/PLSQL:
- Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i, Oracle 8i
LTRIM Function Examples
The LTRIM function can be used in Oracle/PLSQL. For example:
|LTRIM(' tech');||would return 'tech'|
|LTRIM(' tech', ' ');||would return 'tech'|
|LTRIM('000123', '0');||would return '123'|
|LTRIM('123123Tech', '123');||would return 'Tech'|
|LTRIM('123123Tech123', '123');||would return 'Tech123'|
|LTRIM('xyxzyyyTech', 'xyz');||would return 'Tech'|
|LTRIM('6372Tech', '0123456789');||would return 'Tech'|
The LTRIM function may appear to remove patterns, but this is not the case as demonstrated in the following example.
|LTRIM('xxyyxzyxyyxTech', 'xyz');||would return 'Tech'|
It actually removes the individual occurrences of 'x', 'y', and 'z', as opposed to the pattern of 'xyz'.
The LTRIM function can also be used to remove all leading numbers as demonstrated in the next example.
|LTRIM( '637Tech', '0123456789');||would return 'Tech'|
In this example, every number combination from 0 to 9 has been listed in the trim_string parameter. By doing this, it does not matter the order that the numbers appear in string1, all leading numbers will be removed by the LTRIM function.