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

How to estimate disk space needed for an export job?

563

Explain the use of ignore option in imp command.

576

What is the data type of dual table?

529

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

1674

In what script is snap$ created? In what script is the scott/tiger schema created?

2245

Explain oracle’s system global area (sga).

626

How many file formats are supported to export data?

659

How to add another datafile to a tablespace?

578

What is the implicit cursor in oracle?

570

can anyody please send me the dump for Oracle 10g certifications for DBA path?

1692

What is the disadvantage of User defind function?

1833

How do we get field details of a table?

549

Explain oracle’s server parameter file.

566

How to write text literals in oracle?

614

Explain the function of optimizer in oracle?

598