Re: oracle xml question
- From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
- To: ganstadba@xxxxxxxxxxx
- Date: Thu, 14 Jul 2005 11:40:34 +0100
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@xxxxxxxxxxx> 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
> --
> //www.freelists.org/webpage/oracle-l
>
--
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com
Other related posts:
