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!

how to extract attribute value

108275Jan 16 2003 — edited Nov 12 2006

Hi I have xml file which contains:
<DescriptorName MajorTopicYN="N">Human</DescriptorName>
When I run
SELECT extractValue(value(t),'/DescriptorName') AS DESC_HEADING
FROM XMLTABLE X,
TABLE ( xmlsequence (
extract(value(X),
'MedlineCitation/MeshHeadingList/MeshHeading/DescriptorName'))) t
I get all "DescriptorName" values. How can I get "MajorTopicYN" values?
Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 10 2006

Added on Jan 16 2003

#general-xml, #xml

3 comments

10,498 views