Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Ordering of Hierarchical trees by level 1 id

Re: Ordering of Hierarchical trees by level 1 id

From: Andy Hassall <andy_at_andyh.co.uk>
Date: Wed, 14 Jul 2004 13:14:54 +0100
Message-ID: <2t8af0ph3kcg0mot9nlom2l3amagvf497h@4ax.com>


On 13 Jul 2004 03:16:34 -0700, prsingh_at_ipolicynet.com (praveen) wrote:

>I have a table which has a parent child relation represented
>hierachically. I want to run a query to get all trees ordered within
>themselves and also ordered at top level. In other words all trees
>should be ordered by the START WITH id.

 Look into the ORDER SIBLINGS BY clause.

--
Andy Hassall <andy_at_andyh.co.uk> / Space: disk usage analysis tool
http://www.andyh.co.uk         / http://www.andyhsoftware.co.uk/space
Received on Wed Jul 14 2004 - 07:14:54 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US