I have a table with a clob datatype and it contains XML data. I would like to parse out the data and am having issues. Although it's not in the format I want, I can get some output for the XML record with no header info, but nothing for the record that has the header info.
I would like to get multiple rows:
Obviously I'm on the wrong track. I'm new to this and have looked up and tried many examples.
The most progess I can get is:
from XML_INPUT e
...which gives me
<< NO DATA FOR THE RECORD WITH HEADER INFO >>
I've attached a simple sample of the 'create table' and insert of 2 records just for an example.
Any help is appreciated.