Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to count elements in a XMLTYPE of the same type?

600198Feb 4 2008 — edited Mar 15 2011

Hi.

Imagine i have this inside a xmltype :

<world>Mercury</world>
<world>Venus</world>
<world>Earth</world>
<world>Mars</world>

Is there a way to query the xmltype (fast way) to return me 4 ?

Cheers!

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 12 2011

Added on Feb 4 2008

#performance-availability, #xml-db

14 comments

29,767 views