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

Whether any commands are used for months calculation? If so, what are they?

1139

various types of hints and their usage

2751

what is a Nested Loop join?

2175

What is a sub query? What are its various types?

1277

How to connect to a remote server?

1192

What is bulk load in oracle?

1129

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

1932

What is the difference between sharding and replication?

1138

Explain the use of rows option in exp command.

1149

What is the difference between view and materialized view in Oracle?

1208

What is the difference between formal parameters and actual parameters?

1156

How do I learn what codesets are available in oracle?

1080

material view and view disadvantages?

1127

What is index in Oracle?

1133

What is the use of oracle?

1078