XPath Node Regular Expression
Hi,
Does xpath have a way of getting me all the child nodes with look like 'LEAF%'
where '%' is my wildcard character.
Eg:
SELECT EXTRACT
(XMLTYPE
('<ROOT><LEAF1>01</LEAF1>02<LEAF2></LEAF2><BRANCH>03</BRANCH></ROOT>'),
'/ROOT/*'
)
FROM DUAL;
I want to extract 'LEAF1' and 'LEAF2' from the xmltype. Is this possible?