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
- 7780 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
Why use truncate instead of delete?
Does a primary key have to be a number?
How many types of functions are there in sql?
what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba
Does sqlite need a server?
Explain what is table in a database?
Is left join faster than join?
what is the difference between char_length and length? : Sql dba
Can a key be both primary and foreign?
Explain aggregate functions are available there in sql?
What is spool?
What is the purpose of the partition table?
what are the authentication modes in sql server? How can it be changed? : Sql dba
What is the difference between local variables and global variables?
Can a select statement fire a trigger?
