请问在oracle中如何将两列合并成一列select出来
现有一张table.其中里面的两列是:
A B
1 15
2 75
7 2
3 12

请问如何将它们做一列select出来.结果要是这样的:
A
1
2
7
3
15
75
12

感激不尽!

------解决方案--------------------
select a from table
union all
select b from table;
------解决方案--------------------

探讨

select a from table
union all
select b from table;

------解决方案--------------------

探讨

select a from table
union all
select b from table;