Skip to content
Advertisement

Oracle XMLTYPE extract root prolog value

I have sample Query with XML like below:

Output:

enter image description here

I am trying to fetch the values below within the query or a new query: Is there any way to do that? Any help / direction appreciated.

enter image description here

Advertisement

Answer

You just have to complete your first XMLTABLE query (h) in this way:

User contributions licensed under: CC BY-SA
9 People found this is helpful
Advertisement