Hi
How can I get the count of a particular node in the xmltype data. In the below xmltype data, need to check the count of 'actionOf' node i.e how many time it is appearing the xml.
<ExecutionReport xmlns="http://www.fpml.org/FpML-5/recordkeeping" xmlns:fpml="http://www.fpml.org/FpML-5/recordkeeping" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" fpmlVersion="5-5">
<header>
<creationTimestamp>2020-05-28T13:39:02Z</creationTimestamp>
</header>
<isCorrection>false</isCorrection>
<actionOf>
<Reference href="partyA"/>
</actionOf>
<actionOf>
<Reference href="partyB"/>
</actionOf>
</ExecutionReport>
-- Version
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
PL/SQL Release 12.1.0.2.0 - Production
"CORE 12.1.0.2.0 Production"
TNS for Linux: Version 12.1.0.2.0 - Production
NLSRTL Version 12.1.0.2.0 - Production
Regards