Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to extract data from an XML which have different namespace prefixes?

771030May 12 2010 — edited May 20 2010
Hi,

I have XMLs inserted into a XMLTYPE column which are based on a common XSD which allows different namespaces.

How do I extract certain data from these XMLs by using extractvalue when different namespaces will be prefixed for that node?

Thanks and Regards,
A
This post has been answered by odie_63 on May 13 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 17 2010
Added on May 12 2010
4 comments
2,108 views