|Oracle9i SQL Reference
Release 1 (9.0.1)
Part Number A90125-01
Functions, 66 of 166
LTRIM removes characters from the left of char, with all the leftmost characters that appear in
set removed; set defaults to a single blank. If char is a character literal, you must enclose it in single quotes. Oracle begins scanning char from its first character and removes all characters that appear in set until reaching a character not in set and then returns the result.
Both char and set can be any of the datatypes
NCLOB. The string returned is of
VARCHAR2 datatype and is in the same character set as char.
The following example trims all of the left-most x's and y's from a string: