|
|
|
Oracle: Ltrim
Function
The ltrim
function will remove all specified characters from the
left-hand side of the string.
Few examples are as follows:
ltrim(' teacher'); would return 'teacher'
ltrim(' teacher', ' ');
would return 'teacher'
ltrim('000678', '0'); would
return '678'
ltrim('123123Show', '123');
would return 'Show'
ltrim('123123XYZ123', '123');
would return 'XYZ123'
ltrim('xxyyzzABC',
'xyz'); would return 'ABC'
ltrim('4567NEW', '0123456789');
would return 'NEW'