select e.ename from e where e.eid in ( (select e.eid from e minus se

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 / sudipta santra

Answer Posted / sudipta santra

select e.ename from e where e.eid in (
(select e.eid from e
minus
select eid from empdept,d where d.did=empdept.did))

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is a data lock in oracle?

1180

Give the various rollback segment states.

1088

What is the string concatenation operator in oracle?

1228

ABOUT IDENTITY?

2109

What are the system predefined user roles?

1096

What is meant by an index?

1218

how to convert .db (extention) database file into .dmp (extention ) for oracle database ?

2599

What is Java Pool in Oracle?

1237

What is snapshot is too old? Give and example for better understand.

1651

What is proxy method?

1021

Name the various constraints used in oracle?

1078

What is an oracle?

1063

How to convert character types to numeric types?

1191

Explain about the analyze command in oracle?

1109

How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?

2872