oralce表字段的连接

select concat('aa','bb') from dual;

select concat('aa'||' ','bb') from dual;