Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Ordering of Hierarchical trees by level 1 id
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/spaceReceived on Wed Jul 14 2004 - 07:14:54 CDT