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
- 7659 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
how to convert character strings to numeric values? : Sql dba
define join and explain different type of joins? : Sql dba
How to make a copy values from one column to another in sql?
Explain what is rdbms?
Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?
How many functions are there in sql?
what is single byte over head in oracle..?
What is string join?
What are different methods to trace the pl/sql code?
What is an index in sql with example?
what is uncommittable transactions? : Transact sql
Does truncate release storage space?
How to run sql statements with oracle sql developer?
Is it possible for a table to have more than one foreign key?
What are the popular database management systems in the it industry?
