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

How to connect to oracle using service name instead of sid?

626

How would you best determine why your MVIEW couldnt FAST REFRESH?

1511

Can I create users through internet explorer in oracle 10g?

658

Explain the use of log option in exp command.

616

Differentiate between post-database commit and post-form commit?

622

What is the difference between translate and replace?

640

What is a package ? What are the advantages of package ?

698

Explain index?

837

How to define an explicit cursor in oracle?

675

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

638

What is a procedure in oracle?

691

How to use "startup" command to start default instance?

635

What are the four Oracle system processes that must always be up and running for the database to be useable?

673

Can objects of the same schema reside in different tablespace?

666

What is clustered table in Oracle?

722