怎么把数据纵向输出？

Question

Answer 1

这个要用unpivot

with t as (select 0 a,1 b,2 c,3 d from dual)
select * from t unpivot (val for col in (A,B,C,D));