Interested to Buy Any Domain ? << Click Here >> for more details...
There are three tables :
E : EID,ENAME
D : DID,DNAME
empdept : eid, did
select the employees who doesn't belong to any dep
- 4 Answers
- 7810 Views
- Microsoft, I also Faced
- E-Mail Answers
Answer Posted / ajit
select e.eid, e.ename
from E e, D d
where e.eid = d.did(+)
and d.did is null;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is oracle database client?
what is the difference between substr and instr function in oracle?
What are joins, explain all types of joins?
defination of bitmap index
Explain integrity constraints?
What is oracle thin client?
What is the string concatenation operator in oracle?
How to create a table index in oracle?
Explain index?
In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?
Difference between inner join vs where ?
What are data pump export and import modes?
How do I limit the number of oracle database connections generated by weblogic server?
What is the relation of a user account and a schema in oracle?
how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....
