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

4 Answers
7818 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

Please Help Members By Posting Answers For Below Questions

What is different types of joins?

1023

How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?

1919

Explain the difference between a procedure and a function?

1175

What is varray?

1142

What is oracle server autotrace in oracle?

1166

What is translate in oracle?

1100

What are the tools for Oracle ?

1067

What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?

1051

How to do clean up if create database failed?

1031

Explain the truncate in oracle?

968

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

2260

what is meant by magic query

2189

What are triggers in oracle?

1040

How to pass a parameter to a cursor in oracle?

1186

What are ddl statements in oracle?

1076