Simple pivot

Hi,

I've a very simple table (see below(. My database version is 12.2.0.1. Now I want to pivot the content Like this

DBName     DBVersion     MachineName          orcl_gtp_contact          orcl_gtp_line_of_bus

odwh          12.2.0.1.0        linuxs8889               John Doe                    DWH database Dep Sales

I've being experimenting with the pivot function but without success. Can someone give a helping hand?

Thanks,

Ivan

Table XX

PROPERTY_NAME	PROPERTY_VALUE
DBName	odwh
DBVersion	12.2.0.1.0
MachineName	linuxs8889
orcl_gtp_contact	John Doe
orcl_gtp_line_of_bus	DWH database Dep Sales