안녕하세요....... 궁금한게 있어서 문의 드립니다.
with xx01 as(
select 'a' as column1, '1' as column2 from dual union all
select 'b' as column1, '2' as column2 from dual )
select * from xx01
결과가 이렇게 나오자나요....
column1 | column2 |
a | 1 |
b | 2 |
이렇게 나오는 결과를
column |
a |
1 |
b |
2 |
이런식으로 나오게 할수 없나요....
오라클 9i에서도 가능하게 쿼리를 구현하고 싶은데 ... 좋은 방법이 없을까요?
그럼, 수고하세요.
with xx01 as( select 'a' as column1, '1' as column2 from dual union all select 'b' as column1, '2' as column2 from dual ) select decode(lv,1,column1,2,column2) col from xx01 a, (select level lv from dual connect by level <= 2) ; with xx01 as( select 'a' as column1, '1' as column2 from dual union all select 'b' as column1, '2' as column2 from dual ) select column1 from xx01 union all select column2 from xx01 ;