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
7744 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

How to create an oracle testing table?

1047

Explain integrity constraint?

1143

What is blob datatype?

1100

Is there a function to split a string in plsql?

1039

What are the ansi data types supported in oracle?

935

How to define a specific record type?

1072

What is difference between truncate and delete?

1018

how to handle exceptions in post production

1405

What is the scope of a local variable?

1044

Explain the function of optimizer in oracle?

1103

How to delete all rows a table in oracle?

1057

What is an oracle cursor variable?

1047

What is the difference between substr & instr functions?

1201

In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??

1829

Explain alias?

1109