Here i'm sending all of you the error which occurred frequently during database connection.While creating a data block in Oracle Forms, the error which encountered frequently is "ORA-12560: TNS Protocol Adapter Error" During lectures instructor had told us that if such error encountered then copy the TNSNAMES.ORA file from ..oracleora92networkadminsample to forms9inetworkadminsample as it contains...

sahil4439

 Profile Answers by sahil4439 Questions by sahil4439

• Jun 15th, 2008

dude  ur databse is not running...right click on my compiuter>manage>services& applictaions(on right side)>services>oracle_databse_name(the datasbe  that ur  trying ...

Answer Question  Select Best Answer

ID employee department manager----------------------------------------------1 Suresh c++ NULL 2 Suresh c++ NUll3 Suresh c++ 25 Sarathy testing 26 Rajaraman c# 17 joe Flash 1I have the employee detail table ,In that i want to find the manager for each employee .The employee...

Read Best Answer

Editorial / Best Answer

mktiwary  

 Profile Answers by mktiwary Questions by mktiwary

• Member Since Jun-2008 | 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

Nivetha Thinakaran

 Profile Answers by Nivetha Thinakaran Questions 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(+);

poojamohan

 Profile Answers by poojamohan Questions by poojamohan

• Sep 25th, 2012

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

Improve Answer