LTRIM Function in Oracle SQL – PLSQL

The LTRIM Function in Oracle SQL / PLSQL is used to remove the specified characters in a string from the left side.

Syntax for the using the LTRIM Function in Oracle SQL / PLSQL is:

SELECT LTRIM(string_1,[string_2])
FROM table_name;

  • string_1 is the string which will be trimmed from the left side
  • string_2 is the string which will be matched in string_1 for trimming, it’s an optional parameter, if omitted then LTRIM function will remove all the spaces in string_1from left side.

Examples:
Using LTRIM Function in Oracle SQL / PLSQL SELECT statement:

SELECT LTRIM('Tech Honey', 'T')
FROM dual;

Will return ‘ech Honey’

SELECT LTRIM('Tech Honey', 'Tech')
FROM dual;

Will return ‘Honey’

SELECT LTRIM(' Tech Honey')
FROM dual;

Will return ‘Tech Honey’

SELECT LTRIM('56789Tech Honey', '0123456789')
FROM dual;

Will return ‘Tech Honey’

SELECT LTRIM('111111Tech Honey', '1')
FROM dual;

Will return ‘Tech Honey’


Tagged , , , , , , , , , , , . Bookmark the permalink.