Forum Stats

  • 3,836,885 Users
  • 2,262,201 Discussions
  • 7,900,133 Comments

Discussions

Count of a node in xml

User_KEHP1
User_KEHP1 Member Posts: 3 Green Ribbon
edited Jun 2, 2020 12:20PM in PL/SQL XML Programming

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

Tagged:
User_KEHP1

Best Answer

Answers