This content has been marked as final. Show 2 replies
When I was trying to compile a procedure on a 10.2 server I realized that it doesn't support XMLEXISTS, what is the recommended 10.2 equivalent, existsnode?Yes, it's existsNode.
I might be doing it all wrong though, I need to count the number of occurences of a certain node, I haven't found a better way than looping through the data and querying it if a certain occurence existsNot sure what you're after exactly.
This will count the number of Stmt element :
Is that what you need?
select count(*) from test_table t , xmltable( xmlnamespaces(default 'urn:iso:std:iso:20022:tech:xsd:camt.053.001.02') , '/Document/BkToCstmrStmt/Stmt' passing t.object_value ) ;
That's exacly what I needed, thanks!