Order in a hierarchical select

[Quoted] Problem description:

[Quoted] I want to have an order by name within a hierarchical select: SELECT -1, Level, Name, null, to_char(ID)   FROM TABLE
  CONNECT BY PRIOR ID=CHILD_ID
  START WITH ID IN
    (SELECT ID

       FROM TABLE
       WHERE CHILD_ID IS NULL);

The original table content is:

ID Name Child_ID

1     a             3
2     b             4
3     d            null
4     c            null
5     f              4
6     e             4

The hierarchical select result should look like:

c
|-b
|-e
|-f

d
|-a

Thank You

Karoly Received on Thu Dec 16 1999 - 17:06:28 CET