Need help on Unpivot (Columns to rows conversion)
577854May 16 2007 — edited May 16 2007Could you please help me to do unpivot using sql?
Table creation and insertion scripts:
create table REQ
(
ID NUMBER,
VALUE VARCHAR2(20)
);
insert into REQ (ID, VALUE)
values (1, 'HI,HELLO, KARTHI');
insert into REQ (ID, VALUE)
values (2, 'ARE,YOU,FINE,BHAR');
insert into REQ (ID, VALUE)
values (3, '100,200,300');
commit;
I need to view the data in the below format
ID VALUE
1 HI
1 HELLO
1 KARTHI
2 ARE
2 YOU
2 FINE
2 BHAR
3 100
3 200
3 300