OCA 11g Preparation 4

Give name of manager and salary of employee SUNIL.

SQL>select emp_company.salary,manager.mname
from emp_company,manager
where emp_company.ename = 'SUNIL'
and emp_company.ename = manager.ename;

List the employee living in city 'BOMBAY' and those having company located in city 'DELHI'

SQL>select ename from emp_company
where ename In
(select ename from employee where city='BOMBAY') and
cname In (select cname from company where city ='DELHI');