急求Sql语句呀，在线等。

[xkcm]

表T1资源总表
a1 a2 b1 b2
50 60 70 80
30 20 10 5

想得到如下视图

1 a1 50
2 a1 30
3 a2 60
4 a2 20
5 b1 70
6 b1 10
7 b2 80
8 b2 5

这种Sql怎么写？急呀，在线等。

[wiler]

select rownum rid,tab_a.* from
(
select 'a1' colname,a1 value
from t1
union all
select 'a2' colname,a2 value
from t1
union all
select 'b1' colname,b1 value
from t1
union all
select 'b2' colname,b2 value
from t1
) tab_a

[allright_flash]

select rownum, x.*
from (
select 'a1' colname from tab t where t.a1 = a1
union all
select 'a2' colname from tab t where t.a2 = a2
union all
select 'b1' colname from tab t where t.b1 = b1
union all
select 'b2' colname from tab t where t.b2 = b2
) x

[wiler]

是不是各个列的类型不一样啊？这样改看看
select rownum rid,tab_a.* from
(
select 'a1' colname,to_number(a1) value
from t1
union all
select 'a2' colname,to_number(a2) value
from t1
union all
select 'b1' colname,to_number(b1) value
from t1
union all
select 'b2' colname,to_number(b2) value
from t1
) tab_a

[Eric_1999]

select rownum, x.*
from (
select * from tab t where t.a1 = a1
union all
select * from tab t where t.a2 = a2
union all
select * from tab t where t.b1 = b1
union all
select * from tab t where t.b2 = b2
)

[Eric_1999]

select rownum, x.*
from (
select * from tab t where t.a1 = a1
union all
select * from tab t where t.a2 = a2
union all
select * from tab t where t.b1 = b1
union all
select * from tab t where t.b2 = b2
) x

[snowy_howe]

楼上的朋友，不行呀，执行不通过呀。


难道连错误信息也没有吗？？？？？？？？？？？？
！！！！！！！！！！！！！！！！！！！！！！！！！

[Eric_1999]

不是很懂楼主意思。
a1 a2 b1 b2
50 60 70 80
30 20 10 5
行列都固定吗？

[sten]

select rownum rid,tab_a.* from
(
select 'a1' colname,to_char(a1) value
from t1
union all
select 'a2' colname,to_char(a2) value
from t1
union all
select 'b1' colname,to_char(b1) value
from t1
union all
select 'b2' colname,to_char(b2) value
from t1
) tab_a
这样试试，不会有问题的

[xkcm]

楼上的朋友，不行呀，执行不通过呀。