Hai,
I have
proper knowledge in Oracle 9i as wel as PostgreSQL.
I have
written a query in Oracle-SQL like the following...
select
level,substr(lpad(' ',level*2)||ename,1,20) name from emp
start
with ename='KING'
connect by prior empno=MGR;
/
LEVEL
NAME
--
In looking at your result set, it appears that
there is no way of determining which employee is responsible to which manager.
This is how I've done it:
Every employee is assigned a
StationID. For example a Sr. Manager or Administrator is assigned an ID of
'B01' (Business unit 01).
