LTRIM

LTRIM scans a text expression from left to right and removes all the characters that match the characters in the trim expression, until it finds an unmatched character.

Return Value

VARCHAR2 | CLOB

Syntax

LTRIM(char [, set ])

Arguments

char is the text expression to be trimmed.

set is a text expression with the characters to remove. The default value of set is a single blank.

Examples

LTRIM(' . . . .Last Word', ' .') returns the value Last Word.

LTRIM('0001007061985', '01') returns the value 7061985.