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 / ajit
ANS - 2
select d.deptno, dname, loc
from emp e, dept d
where e.deptno(+) = d.deptno
and e.deptno is null;
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What can sql server reporting services do?
What is auto increment?
What is rank () in sql?
How many functions are there in sql?
What is trigger in flip flop?
How can we make an if statement within a select statement?
What is sp_helptext?
What is data type in sql?
Why we use triggers in mysql?
What is #table in sql?
Explain the advantages and disadvantages of stored procedure?
What is the difference between distinct and unique in sql?
What are functions in sql?
what is recursive stored procedure? : Sql dba
What is cursor in pl sql with examples?