Q1.all the depts which has more then 10 empls? Q2.all the
dept which does not have any emply? Q3 all the emp which
does not have any dept? Q4 get all the emply detais with
the dept details it dept is exit otherwise any emp details?
Q5 how to debugg the dynamic sql and packages?
Answer Posted / krish
1)select deptno,count(*)
from emp having count(*)=0 group by deptno;
2)select deptno,count(*)
from emp having count(*)>10 group by deptno;
3)select empname from emp where deptno is null;
4)select emp.deptno,emp.ename,dept.deptno,dept.dname
from emp,dept
where emp.deptno=dept.deptno(+);
Is This Answer Correct ? | 2 Yes | 6 No |
Post New Answer View All Answers
What are the types of join in sql?
What is the difference between the conventional and direct path loader? : aql loader
How you improve the performance of sql*loader? : aql loader
Is it possible to pass parameters to triggers?
how is exception handling handled in mysql? : Sql dba
How do I run a sql query in pgadmin 4?
What is substitution variable in pl sql?
What is mutating error in pl sql?
What are the benefits of triggers?
What is record data type?
Determine if oracle date is on a weekend?
What is java sql driver?
How to process query result in pl/sql?
define sql insert statement ? : Sql dba
How do I delete a trigger?