Re: Select with a CONNECT BY clause
From: Jomarlen <jomarlen_at_aol.com>
Date: 1997/12/02
Message-ID: <19971202222301.RAA00318_at_ladder01.news.aol.com>#1/1
Date: 1997/12/02
Message-ID: <19971202222301.RAA00318_at_ladder01.news.aol.com>#1/1
>SELECT LPAD(' ',2*(LEVEL-1)) || ENAME ORG_CHART,
>EMPNO,
>MGR,
>JOB
>FROM EMP
>START WITH JOB = 'PRESIDENT'
>CONNECT BY PRIOR EMPNO = MGR;
>
>The $20.000 question is: Is there a way to have an alphabetical order in
The answer is not the one you want - it is NO. Connect by and Order by are mutually exclusive. Received on Tue Dec 02 1997 - 00:00:00 CET