This preview shows page 1. Sign up to view the full content.
Unformatted text preview: 8. Select e.deptno department, e.ename employee, c.ename colleague from emp e, emp c where e.deptno = c.deptno and e.empno <> c.empno order by e.deptno, e.ename, c.ename; 9. a. select * from salgrade; b. select e.ename, e.job, d.dname, e.sal, s.grade from emp e, dept d, salgrade s 10. select ename, hiredate from emp where months_between(sysdate, hiredate) < months_between(sysdate, '01-MAY-81') 11. Select e.ename Employee , e.hiredate Emp Hiredate , m.ename Manager, m.hiredate Mgr Hiredate from emp e, emp m where e.mgr = m.empno and e.hiredate < m.hiredate; 12. Select rpad(ename, 8) ||rpad(*, sal/100, *) Employee_and_their_salaries from emp order by sal desc;...
View Full Document
This note was uploaded on 02/21/2012 for the course COMPUTER CS 220 taught by Professor Idk during the Fall '07 term at Capitol College.
- Fall '07