xml - XMD data manipulation using sql query -

i have following xml data in oracle table:

<pivotset><item><column name="item">pid</column> <column name="max(current_value)">c009</column> </item><item><column name="item">customer_name</column> <column name="max(current_value)">xyz info</column> </item><item><column name="item">backup_frequency</column> <column name="max(current_value)">every day</column> </item><item><column name="item">version</column> <column name="max(current_value)">3.1.0</column> </item><item><column name="item">patch_details</column> <column name="max(current_value)">critical fixes</column> 

i want convert data in following tabular format:

pid customer_name  backup_frequency version patch_details c009 xyz info      every day        3.1.0   critcal fixes 

please suggest how can done.