SQL-qwery with a ''connect by prior'' in alfabetic order?(hierachical tree)

From: Paul Broeken <pbroeken_at_casema.net>
Date: Mon, 24 Jan 2000 21:22:07 +0100
Message-ID: <388cb36c$0$20554_at_reader3.casema.net>

[Quoted] How can I make it posssible ordering by ename without losing the hieracical [Quoted] structure (with a ''connect by prior'').

It's like

  select level,

             empno,
             ename

  from emp
  start with mgr is null
  connect by prior empno=mgr

If I use ''order by'' I lose the construction, and I cannot use a "view'' or [Quoted] ''subquery'' cause of the ''connect by''. Does anyone have an idea to solve this problem? (it's the query I need for building a hierachical tree in Forms 6) Received on Mon Jan 24 2000 - 21:22:07 CET