Oracle XML select results into a table

Question

if I have a XML column which elements have the following structure

> <library>
>     <bookshelf>
>         <book>
>         <book>
>           ...
>         <book>
>     </bookshelf> </library>

How can I retrieve all the information and put it into a table which columns look like this LIBRARY BOOKSHELF BOOK?

Community · Accepted Answer · 2017-05-23 12:12:23Z

0

This question might help you with extracting each column wise and inserting.

CommunityBot

11 silver badge

answered Sep 21, 2012 at 17:28

vijayaragavan

1764 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1