DevOps, CI/CD and Automation

Hi,

I need some help in extracting the DATA from an XML. I have the following example XML, and the object element can go multi level deep just like the following. Please share your ideas or any information in extracting this data by an SQL query. I am usig Oracle version 11gR2.

<objects>
<name>foo-1</name>
<object>
<name>foo-2</name>
<object>
<name>foo-3</name>
<object>
<name>foo-4</name>
</object>
</object>
</object>
</objects>

in some cases th XML may be simple like

<objects>
<name>foo-1</name>
<object>
<name>foo-2</name>
</object>
</objects>

Thanks
Ed