1.纵向拼接:
select 'a' a from dual
union
select 'b' b from dual
2.横向拼接:
select 'a' a, 'b' b from dual
1.纵向拼接:
select 'a' a from dual
union
select 'b' b from dual
2.横向拼接:
select 'a' a, 'b' b from dual
转载于:https://my.oschina.net/chenhao901007/blog/355703