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

Can group functions be used in the order by clause in oracle?

940

Is the After report trigger fired if the report execution fails ?

2879

What is SQL Tuning Advisor in Oracle?

1109

please explain.. DB architecture ...

1968

What is an oracle table?

934

How to create a stored function in oracle?

1040

What is oracle used for?

971

How to pass parameters to procedures?

975

How to pass parameters to procedures in oracle?

997

How to join two tables in a single query using oracle?

932

What are group functions in oracle?

975

What is truncate oracle?

917

How to add another datafile to a tablespace?

994

Explain the use of compress option in exp command.

969

What happens in oracle commit?

973