Ltrim – Oracle SQL Function

LTRIM returns a VARCHAR2 string that is the same as arg1 with the characters in arg2 removed.

LTRIM keeps scanning from the left most character and keeps removing characters until none match arg2.

Example:

SELECT LTRIM(‘xxxx-AA’,’x’) as RESULT from dual;

RESU
———
-AA-