1.纵向拼接：
select ‘a‘ a from dual union select ‘b‘ b from dual
2.横向拼接：
select ‘a‘ a, ‘b‘ b from dual
Oracle 字段拼接
原文：http://my.oschina.net/chenhao901007/blog/355703
