There are three tables :
E : EID,ENAME
D : DID,DNAME
empdept : eid, did
select the employees who doesn't belong to any dep
Answer Posted / sudipta santra
select e.ename from e where e.eid in (
(select e.eid from e
minus
select eid from empdept,d where d.did=empdept.did))
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to convert characters to times in oracle?
How do I learn what codesets are available in oracle?
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
How to get execution statistics reports on query statements?
What is the difference between online and offline backups?
What are the attributes of the cursor?
What is a trigger oracle?
How to write text literals in oracle?
When do you get a .pll extension in oracle?
Compare and contrast between sql and sql server and explain its various functions?
WHAT IS ecc 6.0
What are the uses of synonyms?
What are a query and state the different types of queries and their uses?
Explain the use of constraints option in exp command.
Describe the types of sub query?