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.....
sincerely
-nitin khandelwal
university of waterloo
canada