Hey guys,
I'm new in this forum but I'm not that new to Oracle. I have a current problem that I need to generate views from a xml document insertet in a clob. I created a function that selected the data of the file in a varchar2. Now the problem is how to get the string to split the data of the xml, like
<book>
<author>Mr. Dunno</author>
<year>2000</year>
<price>19.99</price>
</book>
into a view named 'book', with the columns 'author', 'year' and 'price'.
Can you push me in the right direction? I dont even know where and what to research.
Sorry for my bad English, I'm not native speaking.
Regards Gerber