不费话，直接查询就行

select trim('  a aa  ') from dual;
select Ltrim('  a aa  ') from dual;
select Rtrim('  a aa  ') from dual;
select Rtrim(Ltrim('  a aa  ')) from dual;
就是这三个函数