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
- 7510 Views
- KPIT, I also Faced
- E-Mail Answers
Answer Posted / girija shankar dash
ANS-3:
SELECT employee_id , department_id
FROM employees
WHERE department_id IS NULL;
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What is out parameter used for eventhough return statement can also be used in pl/sql?
How to fetch values from testtable1 that are not in testtable2 without using not keyword?
who introduced sql?
What are the 3 types of behavioral triggers?
What are the syntax and use of the coalesce function?
What is the need of merge statement?
Which are the different types of indexes in sql?
Define concurrency control. : Transact sql
Mention what does plv msg allows you to do?
Does sql backup shrink transaction log?
What does count (*) do in sql?
what is table? : Sql dba
What is record variable?
What are the three forms of normalization?
How do you write a complex sql query?
