Convert columns to rows:
create table tr1 (name varchar2(10), cust_value_1 number,cust_value_2 number,cust_value_3 number);
insert into tr1 values(‘a’,1,1,1);
insert into tr1 values(‘b’,1,0,1);
insert into tr1 values(‘c’,0,0,1);
–transform sql
select * from (
select name,
case when rowno=1 then cust_value_1
when rowno=2 then cust_value_2
when rowno=3 then cust_value_3
end cust_value
from tr1, (select rownum rowno from dual connect by level <= 3)
)
order by name;
NAME CUST_VALUE
———- ———-
a 1
a 1
a 1
b [...]
Filed under: Data Management | 1 Comment »