Skip to Main Content

Count of a node in xml

User_KEHP1Jun 2 2020 — edited Jun 2 2020

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

Comments
Post Details
Added on Jun 2 2020
2 comments
515 views