Hi, I have a table having 2 columns EmployeeId (int) and EmployeeDetails(XMl type)
EmployeeId EmployeeDetails
1 <Employee><EmployeeDetails><EmployeeName> Priyanka </EmployeeName><Age> 24 </Age><Address> Argentina</Address></EmployeeDetails></Employee>
2 <Employee><EmployeeDetails><EmployeeName> Sarkar </EmployeeName><Age> 28 </Age><Address> Australia</Address></EmployeeDetails></Employee>
I need to have the output like
EmployeeId EmpName Age Address
1 Priyanka 24 Argentina
2 Sarkar 28 Australia
Please help as I am new to xml