DB 11gR2
create table t (
ID int,Attribute varchar2(1),Value int
);
insert into t values (1,'X',3);
insert into t values (2,'Y',4);
insert into t values (3,'X',5);
insert into t values (4,'X',6);
insert into t values (5,'Y',7);
insert into t values (6,'Z',8);
insert into t values (7,'A',9);
create table t1 (
ID int,Attribute varchar2(1),Value int
);
insert into t values (1,'X',3);
insert into t values (2,'Y',4);
insert into t values (3,'X',5);
insert into t values (4,'X',6);
insert into t values (5,'Y',7);
insert into t values (6,'Z',8);
insert into t values (7,'A',9);
output :
i wanted display all values into rows wise record as of now i am getting it as clumne wise so i have used PPIVOT to do the same.
select * from (
select ID, Attribute, Value
from t where id = 1
)
pivot
(
sum(ID)
for Attribute in (select Attribute from t1) ---> this gives me Missing expression error if i use Static values it works something like ('X','Y')
)
Ref : sql - How to convert Columns into Rows in Oracle? - Stack Overflow