I think oracle is poor in doing aggregation function on xml fragments.
what I mean is:
suppose u have article document
<!ELEMENT ARTICLE (AUTHOR+)>
<!ELEMENT AUTHOR (#PCDATA)>
<!ATTLIST ARTICLE ID KEY #REQUIRED>
I store all articles in table articles
create table articles of XMLType;
I want to find number of authors in each article....how do i do it .....any idea.... The problem is when I extract all authors in a given article then Oracle returns a fragment...clubbed all authors in one XMLType attribute. and I just don't know how many xml fragments are there, i.e. I cannot get a count of the authors.
Thanks in advance.....
university of waterloo