DevOps, CI/CD and Automation

Oracle Version : Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bi

Hi All,

I have the below xml , i would like to get the count(nodes) under <ts:updatewr> . how many nodes under <ts:updatewr>
In this case it will be 6. please let me know how can i achieve this, i tried several option with xmltable all failed.

Thanks in advance
Rubu.

<?xml version="1.0"?>
<ts:rowset xmlns:ts="http://msw.ss.com/xsd/Test">
<ts:row>
<ts:updatewr>
<ts:wr_no>18379</ts:wr_no>
<ts:company_cd>2</ts:company_cd>
<ts:crew_hq_cd>5L5G</ts:crew_hq_cd>
<ts:entry_dt>2012-06-30T17:00:00-5:00</ts:entry_dt>
<ts:entry_person_ntid>rdennis</ts:entry_person_ntid>
<ts:local_office_cd>2080</ts:local_office_cd>
</ts:updatewr>
</ts:row>
</ts:rowset>