By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
with tab( Key, attr_name, attr_value ) as
(
select 1234, 'SS_VALUE' ,'SENSITIVE' from dual union all
select 1234, 'XX_VALUE' , '4456' from dual
)
select *
from
( select * from tab )
pivot
(
max(attr_value) for attr_name in ( 'SS_VALUE' as ss_value, 'XX_VALUE' as xx_value )
)
| KEY | SS_VALUE | XX_VALUE |
|---|---|---|
| 1234 | SENSITIVE | 4456 |