* Extract these rows * Cross-Join them with the same table Cautions - Pulling out XML data takes a lot of reconfiguring the data. Hence, it is wise to minimize the data searched if practical. - It would be hard to conceive of a syntax more confusing than that chosen by the SQL standards body for this functionality.
I cannot get the extract function to return the value in inner nodes when the xml has multiple namespaces. Here is the sample code. I have tried a multitude of namespace parameter values with no luck. I can retrieve the outer node - presumably because only one namespace applies to this node declare XML_WITH_NS clob; LEVEL_1_NODE clob;