select e.eid, e.ename from E e, D d where e.eid = d.did(+) and d.did is

There are three tables :
E : EID,ENAME
D : DID,DNAME
empdept : eid, did

select the employees who doesn't belong to any dep

Question Posted / ajit

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

Please Help Members By Posting Answers For Below Questions

What to do if the binary spfile is wrong for the default instance?

564

How to invoke the data pump export utility?

564

In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?

1786

How to get execution path reports on query statements?

566

What is raw datatype in oracle?

583

What are the oracle built-in data types?

564

How to install oracle database 10g xe?

564

What is an oracle and why it is used?

623

What is tns service name?

624

Can we use oracle pl/sql block in core java? if so how? pls get back to me .....

2505

How to experiment a data lock in oracle?

598

How to use "while" statements in oracle?

738

What is where clause in oracle?

534

Difference between the “verify” and “feedback” command?

773

State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.

609