Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Sort Hierarchical Queries

81364Jan 31 2002 — edited Feb 10 2003
Hi Everybody,

how can I sort hierarchical queries by each branch?
I want to determine the order by myself e.g. with a
extra column. For Example I get from the query following:
root
|- A 3
|- A 5
|- A 1
...

But I want to get a sorted tree like that:
root
|-A 1
|-A 3
|-A 5
...

Thanx Thomas
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 10 2003
Added on Jan 31 2002
4 comments
201 views