Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> oracle xml question

oracle xml question

From: Michael McMullen <ganstadba_at_hotmail.com>
Date: Wed, 13 Jul 2005 14:39:48 -0400
Message-ID: <BAY103-DAV18FA883606468AB8DDA832A6DE0@phx.gbl>


9.2.0.5

Any one know how to figure out how many nodes there might be in an xmltype column

ex
xmltype column will have
order

   suborder
   suborder
   suborder
   could be one or more suborders - theoretically no limit order

I need to find a way to know how many suborders there might be in order to generate a select using extract to display it for users.

thanks

Mike

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jul 13 2005 - 13:43:02 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US