1. SQL> select empno, ename from emp where deptno=(select deptno from dept where dname='RESEARCH');
2. SQL> select empno, ename from emp where deptno in (select deptno from dept where loc in ('NEW YORK','CHICAGO'));
3. SQL> select dname from dept where deptno in ( select deptno from emp where job ='ANALYST');
4. SQL> select empno, ename, mgr from emp where mgr = (select empno from emp where ename='JONES');
5. SQL> select empno, ename, mgr from emp where mgr = (select mgr from emp where ename='JONES')
6. SQL> select empno, ename, job from emp where deptno in ( select deptno from dept where dname in ('SALES','ACCOUNTING'))
7. SQL> select empno, ename, job from emp where deptno in ( select deptno from dept where dname in ('SALES','RESEARCH')) and empno in (select mgr from emp)
8. SQL> select empno, ename from emp where empno not in ( select mgr from emp where mgr is not null)
9. select…
Comments
I am Gowrishankar one of ur student in QSpiders.. M not able to attend the tuesday class as i told yesturday M GOING TO SUBMIT MY PROJECT REPRT to my guid so kindly send me the tuesday meterial to my mail...my mail id is..
gowrishankar.gc@gmail.com
"while installing i got abnormal program termination. an internal error has occurred. please provide the following to oracle support:
unknown
unknown
unknown."
oracle initialization or shutdown in progress is the error its showing when i tried to login . please help me with this.
"while installing i got abnormal program termination. an internal error has occurred. please provide the following to oracle support:
unknown
unknown
unknown."
I have a table with date format'YYYYMMDD' i want to retrieve only data for present date, whenever i run that view, it should show only data for present date,
Pls reply it will be great help arif.sindagikar@gmail.com