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
Code snippets and tips
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