Hi All,
12.1
Hopefully a very simple question, but for some reason I cannot figure it out.
Given a simple treewalk, i.e.
select
lpad(' ',level*2,' ')||ename
ename,
empno,
mgr
from emp
START WITH MGR IS NULL
CONNECT BY PRIOR EMPNO = MGR
which produces the following:
How do I refine the query to just get (for example) Just Adams and his managers? (I clearly cannot put a where clause for Adams)
Many Thanks
Richard