I'm not meaning to be rude or presumptious here, but wouldn't a
straightforward couple of relational tables be more appropriate for your
order/suborder structure?
On 7/13/05, Michael McMullen <ganstadba_at_hotmail.com> wrote:
>
> 9.2.0.5 <http://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
>
--
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jul 14 2005 - 05:42:31 CDT
