Suggestions: Hierachical Query

From: Stephan Voigt <svoigt_at_voigt-gmbh.de>
Date: Sat, 18 Apr 1998 12:31:38 +0200
Message-ID: <3538810A.1031E5FC@voigt-gmbh.de>

Hi all,

I currently use a hierachical Query with the "connect by prior" clause. So far everything is ok. I get a result set with parents and childs.

The problem is, that the childs from each parent are unsorted. But for my application
I need a sorted hierachical result set.

How can I do that ?

If I add order by to the statement, the hierachical stucture is destroyed.
I have not found any way to manage this.

Please help ! Received on Sat Apr 18 1998 - 05:31:38 CDT