For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
select * from xmltable ( xmlnamespaces (default 'http://www.fpml.org/FpML-5/recordkeeping') , '/ExecutionReport/count(actionOf)' passing xmltype('<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>') columns cnt number path '.'); CNT---------- 2
select * from xmltable ( xmlnamespaces (default 'http://www.fpml.org/FpML-5/recordkeeping') , '/ExecutionReport/count(actionOf)' passing xmltype('<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>') columns cnt number path '.');
CNT---------- 2
Thanks, this helps.