Hi
I have a table like below
with my_tt as (
select 1 id, 1 EXTERNALid , 'ELEM01' TYPE_ELEMENT,'CLS01' TYPE_CLASS , 'E' TYPE_IND FROM DUAL UNION ALL
SELECT 2 , 1, 'ELEM02','CLS02', 'R' FROM DUAL UNION ALL
SELECT 3,1, 'ELEM03', 'CLS03' ,'D' FROM DUAL )
SELECT *
FROM MY_TT
I would like to get data like below , using TYPE_IND
select 1 EXTERNALid, 'ELEM01' TYPE_ELEMNT_E, 'CLS01' TYPE_CLASS_E, 'ELEM02' TYPE_ELEMNT_R,'CLS02' TYPE_CLASS_R,'ELEM03' TYPE_ELEMNT_D,'CLS03' TYPE_CLASS_D FROM DUAL
all examples I have seen using PIVOT, there is sum or count
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
PL/SQL Release 11.2.0.4.0 - Production
CORE 11.2.0.4.0 Production
TNS for Linux: Version 11.2.0.4.0 - Production
NLSRTL Version 11.2.0.4.0 - Production