Dynamic way to transpose raw to column
Hello All,
I want to transpose row data into column.. and i have the following way to do it in case there is fixed column name.. the following query give me proper result no issue at all.
But In case I have dynamic column name, how I can manage this view ? Can anyone please provide me a good way (mostly dynamic way) of doing this?
create view hardware_data as
SELECT DISTINCT hardware_id,
max(DECODE(data_key,'Platform Type', data_value)) PlatformType,
max(DECODE(data_key,'Platform Manufacturer', data_value)) PlatformManufacturer
from verifier_capability
group by hardware_id
order by hardware_id;
0