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

Explain index?

1240

Explain a data segment?

1046

Define oracle database

1021

What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?

1080

What are the various types of snapshots ?

1009

Point out the difference between user tables and data dictionary?

965

How can Oracle users be audited?

1087

What is a schema in oracle?

999

What is oracle host variable?

1039

How do I connect to oracle database?

1087

What is the quickest way to export a table to a flat file?

949

What is the difference between count (*), count (expression), count (distinct expression)?

988

Explain about your project and its relation to the current job position you are applying to?

987

State and explain the different types of data models?

924

Explain cascading triggers.

1053