Need help in converting XML data in to rows
Please help to load the XML data into columns. Thanks
XML Stored in a column name called 'Form_data'(CLOB data type) under table Form_Master and need to get output as below. Attached XML below.
| Description | Applicable | Position | Remarks | ||
| Entry to VRA | YES | 10/1/2016 | 10/3/2016 3:50 | 07 32.1N / 078 00.0E | Estimated time |
| Exit from VRA | YES | 10/13/2016 | 10/3/2016 1:50 | 07 32.1N / 078 00.0E | Estimated time |
| Entry to HRA | YES | 10/3/2016 | 10/3/2016 10:00 | 12 23.0 N / 065 00.0 E | Estimated time |
| Exit from HRA | YES | 10/10/2016 | 10/3/2016 8:00 | 12 23.0 N / 065 00.0 E | Estimated time |
| Embarkation of Armed Guards | YES | 9/30/2016 | 10/3/2016 12:30 | Colombo | Actual time |
| Disembarkation of Armed Guards | YES | 10/13/2016 | 10/3/2016 7:00 | Colombo | Actual time |
<?xml version='1.0' encoding='utf-8'?><FormsManagement xmlns='generic'><High_Risk_Piracy_Area_Transit_Checklist_table_1 attr='High Risk Piracy Area Transit Checklist table 1'><High_Risk_Piracy_Area_Transit_Checklist_0_0 attr='High Risk Piracy Area Transit Checklist 0 0'><Voyage_No attr='Voyage No'>02</Voyage_No></High_Risk_Piracy_Area_Transit_Checklist_0_0><High_Risk_Piracy_Area_Transit_Checklist_1_1 attr='High Risk Piracy Area Transit Checklist 1 1'><Voyage_From attr='Voyage From'>Luanda</Voyage_From><Voyage_To attr='Voyage To'><![CDATA[Las Palmas via load port Cape Lopez, Gabon]]></Voyage_To></High_Risk_Piracy_Area_Transit_Checklist_1_1><High_Risk_Piracy_Area_Transit_Checklist_1 attr='High Risk Piracy Area Transit Checklist 1'><High_Risk_Piracy_Area_Transit_Checklist_Yes_2 attr='High Risk Piracy Area Transit Checklist Yes 2'>on</High_Risk_Piracy_Area_Transit_Checklist_Yes_2><High_Risk_Piracy_Area_Transit_Checklist_No_3 attr='High Risk Piracy Area Transit Checklist No 3'></High_Risk_Piracy_Area_Transit_Checklist_table_1><HRA_Entry_Exit_table attr='HRA Entry Exit table'><HRA_Entry_Exit_1 attr='HRA Entry Exit 1'><VRA_Entry_NA_YES attr='VRA Entry Applicable'>1</VRA_Entry_NA_YES><VRA_Entry_Date attr='VRA Entry Date'>2016-09-29</VRA_Entry_Date><VRA_Entry_Time attr='VRA Entry Time'><![CDATA[2016/10/03 11:30:00]]></VRA_Entry_Time><VRA_Entry_Position attr='VRA Entry Position'><![CDATA[08 43 S, 012 58 E]]></VRA_Entry_Position><VRA_Entry_Remarks attr='VRA Entry Remarks'><![CDATA[Dep Port Luanda, Angola]]></VRA_Entry_Remarks></HRA_Entry_Exit_1><HRA_Entry_Exit_2 attr='HRA Entry Exit 2'><VRA_Exit_NA_YES
0