while searching forum i found this
9588836
is there a way i can order this tree alphabetically so that result looks like
LEVEL INDENTED_ENAME
---------- --------------------
1 KING
2 BLAKE
3 ALLEN
3 JAMES
3 MARTIN
3 TURNER
3 WARD
2 CLARK
3 MILLER
2 JONES
3 FORD
4 SMITH
3 SCOTT
4 ADAMS
---------original query----------
SELECT LEVEL
, LPAD (' ', 3 * LEVEL) || ename AS indented_ename
FROM scott.emp
START WITH mgr IS NULL
CONNECT BY mgr = PRIOR empno
;
LEVEL INDENTED_ENAME
---------- --------------------
1 KING
2 JONES
3 SCOTT
4 ADAMS
3 FORD
4 SMITH
2 BLAKE
3 ALLEN
3 WARD
3 MARTIN
3 TURNER
3 JAMES
2 CLARK
3 MILLER