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 install oracle odbc drivers?

1058

what is a Nested Loop join?

2057

what are steps for interface? where is exchange rate defined in which table?

2090

What is enter substitution variable in oracle?

1009

What is null value in oracle?

1062

What is blob datatype?

1075

How to get a create statement for an existing table?

927

What privilege is needed for a user to create views in oracle?

1004

What is meant by recursive hints in oracle?

1052

What is the disadvantage of User defind function?

2263

Oracle

2336

Give the various exception types.

960

What is max rowid in oracle?

988

What is java oracle used for?

988

What are the uses of synonyms?

1106