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!

Search in one XML Clob and extract, if found, a specific tag

412237Jan 4 2004 — edited Jan 27 2004

I want to search a string in one specific XMLType column. If the specific string is found the whole tag including the string should be returned.
I tried many solutions, but everything returned the whole document.
With SELECT extract(doc, '//TEST[STR="t1"]')... only a exact match is possible as far as i know.

Can anyone help me?
Thanks.
Stefan

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 24 2004

Added on Jan 4 2004

#pl-sql-xml-programming, #xml

1 comment

283 views