[comp.databases] Sorting of connect by queries in ORACLE

be@dde.uucp (Bjorn Engsig) (02/23/88)

In ORACLE you may do

  select empno,mgr,job,level
  from emp
  connect by prior empno = mgr
  start with mgr  is null

to retrieve all employees in a tree structured order.  There is
however no simple way to specify, that you want some order by clause
on each level in the tree.  Does anybody know how this can be done,
preferably in pure SQL. (I know I can write a recursive program to do
it.)

Please email replies and I will followup.
-- 
Bjorn Engsig, E-mail:  ..!uunet!mcvax!diku!dde!be  or  be@dde.uucp
--
Hofstadters Law: It always take longer than you expect, even if you take into
		 account Hofstadters Law.