See some good examples regarding XMLSequence on the XMLDB forum on otn.oracle.com or look at http://technology.amis.nl/blog/index.php?p=567 regards, Marco -----Original Message----- From: Michael McMullen [mailto:ganstadba@xxxxxxxxxxx] Sent: donderdag 14 juli 2005 14:23 To: ddavey@xxxxxxxxxx; oracle-l@xxxxxxxxxxxxx Subject: 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@xxxxxxxxxx> To: <ganstadba@xxxxxxxxxxx>; <oracle-l@xxxxxxxxxxxxx> 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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Michael McMullen > Sent: 13 July 2005 14:40 > To: oracle-l@xxxxxxxxxxxxx > 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 > -- > //www.freelists.org/webpage/oracle-l > -- > //www.freelists.org/webpage/oracle-l > -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l