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