Oracle Database String Manipulation LTRIM / RTRIM
Example
LTRIM and RTRIM remove characters from the beginning or the end (respectively) of a string. A set of one or more characters may be supplied (default is a space) to remove.
For example,
select LTRIM('<===>HELLO<===>', '=<>')
,RTRIM('<===>HELLO<===>', '=<>')
from dual;
Returns:
HELLO<===>
<===>HELLO
