Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Ordering Hierarchical Queries
Hi,
I have a question about hierarchical queries.
Suppose I have a table:
PARENT NOT NULL VARCHAR2(10) CHILD NOT NULL VARCHAR2(10) SORT_ORDER NUMBER(5)
I want to do a hierachical query, I could do:
select parent, child, sort_order, level
from relation
connect by parent = prior child start with parent = 'A' ;
But, if I want the out put sorted via sort_order and at the same time preseved the level.
How should I do it?
Thanks in advance.
Lin Junmin. Received on Wed Mar 25 1998 - 00:00:00 CST