Oracle8i SQL Reference Release 2 (8.1.6) A76989-01 |
|
Functions, 48 of 121
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.
SELECT LTRIM('xyxXxyLAST WORD','xy') "LTRIM example" FROM DUAL; LTRIM example ------------ XxyLAST WORD
|
![]() Copyright © 1999 Oracle Corporation. All Rights Reserved. |
|