Re: oracle xml question

We used to have an ordering system which we reported on. It had about 10 tables, normal heap tables. They've switched it all and now we get one xmltype column with all the data. We have other groups still relying on the old format. So we want to get the data from the xmltype column and insert it into multiple tables. I've been all over the place digging up examples, asktom, oracle etc. So I have to build an insert statement and I can have one to many multiple suborders. I didn't see xmlsequence but I'll check that out.

Thanks for answering
Mike
----- Original Message -----
From: "Davey, Alan" <ddavey_at_harris.com>
To: <ganstadba_at_hotmail.com>; <oracle-l_at_freelists.org> Sent: Wednesday, July 13, 2005 4:51 PM
Subject: RE: oracle xml question

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

--
http://www.freelists.org/webpage/oracle-l