DevOps, CI/CD and Automation

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!

extracting xmltype and excluding All namespace tags?

939605May 24 2012 — edited Jun 4 2012

Hi all,
I am trying to extract xmltype column into another xmltype column in a different table.

select xt.attachment_content, xt.attachment_type, xt.attachment_format
FROM document_version dva,
XMLTABLE (
XMLNamespaces('http://oracle.com/test1/1.0'),
'AttachmentList/Attachment'

PASSING document_content
COLUMNS
attachment_content xmltype path 'content',
attachment_type varchar2(100) path 'type',
attachment_format varchar2(100) path 'format') xt

This query returns results BUT content has namespaces and tags in the result set too. I just want it to return the contents only NO xml version no xmlns: (xmlnamespaces ) and etc.

Please help me how to I do that.

This post has been answered by odie_63 on May 26 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 2 2012

Added on May 24 2012

#11g, #general-xml, #xml

12 comments

2,871 views