<M Name="def" Code="A5">
<M Name="jhk" Code="B5">
<L Name="xyz" Code="C5">
<A Name="W1" Code="W5">
I have a xmlfile like the above example, how do i do select * from xmltable so that I can get all columns loaded into a table.
I want the select statement for the following table:
MName Mcode LName Lcode AName Acode sname
Thanks in advance.
What have you tried? There are plenty of examples on the forums and I know you have seen some of them. Post an example of what you have tried, along with where your issue is and then we can help you from there.