sahil4439

 Profile Answers by sahil4439 

• May 26th, 2008

 

select employee_manager
from talbe_name;

mktiwary

 Profile Answers by mktiwary 

• Jun 6th, 2008

 

If you take the normal Oracle Employee (emp) table which consists of columns such as Employee Number (EMPNO) and Manager Number (MGR) then the query to find managers for all the employee is:

select e.ename as Employee, m.ename as Manager from emp e, emp m
where e.MGR = m.EMPNO

shiv_prakash

 Profile Answers by shiv_prakash 

• Jun 27th, 2008

 

select column from table where column like '%' ESCAPE '' ;

krishnaveni_g

 Profile Answers by krishnaveni_g 

• Jul 11th, 2008

 

we can find manager for employee in the same table by using self join.

Ex:emp_id   emp_name   manager_id
       1          Smith            
       2          Rahul              1
       3          Sachin             2

Select e.emp_id,e.emp_name,m.last_name from
employees e, employees m
where e.manager_id = m.employee_id;

shiiva

 Profile Answers by shiiva 

• Sep 22nd, 2008

 

SELECT e.ename as Manager, m.ename as Employee FROM emp e, emp m WHERE e.MGR = m.EMPNO

OracleLearner

 Profile Answers by OracleLearner 

• Jan 11th, 2012

 

The code below retrieves the manager name. Note that employees who do not have manger is also listed.
Select
Emp1.Employee_Id,
Emp1.first_name,
Emp1.last_name,
Emp1.Manager_id,
Emp2.first_name as "Manager_First",
Emp2.last_name as "Manager_Last"
from
employees emp1, employees emp2
where
emp1.manager_id = emp2.employee_id(+)
order by emp2.employee_id

rohitosu

 Profile Answers by rohitosu 

• Jul 31st, 2012

 

Code
SELECT a.employee_id, a.manager_id, A.FIRST_NAME Employee_Name, B.FIRST_NAME Manager_Name


    FROM employees a


    INNER JOIN employees b 


    ON A.MANAGER_ID = B.EMPLOYEE_ID 


    ORDER BY A.EMPLOYEE_ID ;

poojamohan

 Profile Answers by poojamohan 

• Sep 25th, 2012

 

How to get the old manager name ,if the employee has been changed to other manager?

Nivetha Thinakaran

 Profile Answers by Nivetha Thinakaran 

• May 6th, 2015

 

Code
SELECT e.employee_id,e.manager_id FROM


employees e,employees m


WHERE e.manager_id=m.employee_id(+);