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?
- 4 Answers
- 6829 Views
- KPIT, I also Faced
- E-Mail Answers
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 is the largest value that can be stored in a byte data field?
how to dump a table to a file with 'mysqldump'? : Sql dba
Can a table have no primary key?
what are date and time intervals? : Sql dba
What is $$ in sql?
How is debugging done?
What are the parts of a sql statement?
What sql database should I use?
How does one load ebcdic data? : aql loader
Is trigger a stored procedure?
What is the usage of when clause in trigger?
Why do we use %rowtype & %type in plsql?
what is bcp? When does it used? : Sql dba
Why having clause is used in sql?
Can we insert data into view?
