Question

ORACKLE一个表中有a,b,c,d;4个字段，我想把这4个字段值转到新得一列，SQL怎么写，

例如：
转成





Answer 1

select dba as reason from biao
union all
select loan from biao
union all
select mortdue from biao
union all
select value from biao