RE: oracle xml question

From: Davey, Alan <ddavey_at_harris.com>
Date: Wed, 13 Jul 2005 16:51:45 -0400
Message-ID: <A223847B255BF54FBE6AFEEF58F0C16F8744A0@mlbe2k6.cs.myharris.net>

Hi Michael,

I'm not sure why you need the count in order to select all of the suborders, unless you are planning on looping and extracting one suborder at a time.

Take a look at the xmlsequence() function. You can get all of the suborders for a specific order in one select statement using xmlsequence and extract. I'm not in the office so I don't have an example handy at the moment, but the Oracle documentation has a one or two examples that you can likely apply to your situation.

HTH,

Alan Davey
Senior Programmer/Analyst, Advertising Solutions Harris Corporation
w) 212-295-3458

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Michael McMullen Sent: 13 July 2005 14:40
To: oracle-l_at_freelists.org
Subject: oracle xml question

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
--

http://www.freelists.org/webpage/oracle-l Received on Wed Jul 13 2005 - 15:53:48 CDT