去前后空格函数:
select trim(' a aa ') from dual;
select Ltrim(' a aa ') from dual;
select Rtrim(' a aa ') from dual;
select LTRIM(RTRIM(INVNo)) from dual;