PL/SQL – selecting count on nodes in XML

This is sample on how to select the number of nodes in xml field in a Oracle table.

 

select  count(*) from TEST.M_DATA md, table ( xmlsequence(extract(MD.XML_DATA, '/catalog/styles/style'))) xml

Leave a Reply

Your email address will not be published. Required fields are marked *