Hi,
I have a table with records similar to below. I want to convert rows into column based on the 2 fields.
Oracle Version 11.2
Source Table:
with tbl_nm as
(
select 'Joby' NM, 'A' GRP, 'ACFHFJ' CODE from dual union
select 'Joby' , 'B' , 'HFJUNG' from dual union
select 'Joby' , 'C' , 'BHJFGH' from dual union
select 'Paul' , 'A' , 'JKUMGH' from dual union
select 'Paul' , 'B' , 'KJUNHG' from dual union
select 'Matt' , 'B' , 'HFUFJF' from dual union
select 'Matt' , 'C' , 'HGJGUN' from dual union
select 'Anna' , 'A' , 'JDHDUG' from dual union
select 'Anna' , 'C' , 'JGUGNH' from dual
)
select * from tbl_nm
Output I need:
with tbl_nm as
(
select 'Joby' NM, 'ACFHFJ' A, 'HFJUNG' B, 'BHJFGH' C from dual union
select 'Paul' , 'JKUMGH' , 'KJUNHG' , NULL from dual union
select 'Matt' , NULL , 'HFUFJF' , 'HGJGUN' from dual union
select 'Anna' , 'JDHDUG' , NULL , 'JGUGNH' from dual
)
select * from tbl_nm
Can someone please help on this?
Thanks,
Gangadhar