LTRIM

Purpose

This function deletes all characters in char2 from the left end of char1 until a character not in char2 is found at the left end of char1, and returns the result.

Syntax

LTRIM(char1 [,char2])

Parameters

Return type

• If char1 is of the CHAR or VARCHAR2 data type, the function returns a value of the VARCHAR2 data type.

• If char1 is of the NCHAR or NVARCHAR2 data type, the function returns a value of the NVARCHAR2 data type.

• If char1 is of the LOB data type, the function returns a value of the LOB data type.

Examples

Remove the extra characters before Hello World! in the string #a￥!aa￥ Hello World!.

obclient> SELECT LTRIM('#a￥!aa￥  Hello World!','#a￥! ') text FROM DUAL;
+--------------+
| TEXT         |
+--------------+
| Hello World! |
+--------------+
1 row in set