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
- 7585 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
How to start the command-line sql*plus?
how to extract a unit value from a date and time? : Sql dba
Can I call a procedure inside a function?
what are different types of collation sensitivity? : Sql dba
Is record in pl sql?
how to enter numeric values as hex numbers? : Sql dba
How to write html code in pl sql?
Explain what is a field in a database and record in a database?
What are the different schemas objects that can be created using pl/sql?
What is pragma in sql?
What is consistency?
What is left join in postgresql?
What is the difference between delete and truncate statement in sql?
How to select 10 records from a table?
Is inner join same as self join?
