Oracle XML select results into a table

Slarge

New Member
if I have a XML column which elements have the following structure\[quote\]\[code\]> <library>> <bookshelf>> <book>> <book>> ...> <book>> </bookshelf> </library>\[/code\]\[/quote\]How can I retrieve all the information and put it into a table which columns look like thisLIBRARY BOOKSHELF BOOK?
 
Back
Top