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
- 7435 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 procedure in pl sql?
what is dbms? : Sql dba
Can triggers stop a dml statement from executing on a table?
What is the difference between sql and mysql?
How many sql core licenses do I need?
What do you mean by field in sql?
How to sort the rows in sql.
What is difference between inner join and cross join?
How many columns should be in an index?
what is cross join? : Sql dba
How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?
What is a join?
How do you take the union of two tables in sql?
How can you select unique records from a table?
What is the default isolation level in sql server? : Transact sql
