Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 7643 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 importance of sqlcode and sqlerrm?
Is left join same as join?
What is data types in sql?
What is scalar data type in pl sql?
How to raise user-defined exception with custom sqlerrm ?
what is oracle database ? : Sql dba
What is the difference between truncate and drop statements?
how to load data files into tables with 'mysqlimport'? : Sql dba
How would you convert date into julian date format?
What does a pl/sql package consist of?
Does view store data in sql?
What is scalar function in sql?
How do I run pl sql in sql developer?
Is a secondary key the same as a foreign key?
what is sub-query? : Transact sql
