How to parse XML in PL/SQL

MoathS

New Member
I have following xml struct in pl/sql:\[code\]<struct> <member> <name>CODE</name> <value> <integer>0</integer> </value> </member> <member> <name>MSG</name> <value> <string>Some message</string> </value> </member></struct>\[/code\]How can i extract values in path /member/value/some_type using text in name tag?I mean something like this:\[code\]extract('//member/value/*[filter name tag = CODE]').getStringValue\[/code\]
 
Back
Top