Trimming of heading characters from a character string.
The leftmost characters that appear in the set are removed.
Syntax: LTRIM(CHAR,SET)
Example:
The leftmost characters that appear in the set are removed.
Syntax: LTRIM(CHAR,SET)
Example:
| Use of LTRIM Function |
|---|
| SELECT 'xyzXxyORACLE' OrgStr,LTRIM('xyzXxyORACLE', 'xzyX') Ltrim FROM DUAL; |
| SELECT LTRIM(' Oracle') FROM DUAL; --trimming space |
No comments:
Post a Comment