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
- 7640 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
Is it possible to read/write files to-and-from PL/SQL?
what are the different index configurations a table can have? : Sql dba
What does pl sql developer do?
What does count (*) mean in sql?
Can we insert data into materialized view?
How do you optimize a stored procedure query?
What is left join in sql?
What is the use of prepared statement?
What is schema in sql?
define data blocks ? : Sql dba
How to select random rows from a table?
What is procedure explain with program?
what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba
I need a function for a train ticket reservation please answer it thanks in advance
What can sql server reporting services do?
