SELECT ename FROM emp WHERE NOT EXISTS (SELECT NULL

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 / nathan

Answer Posted / nathan

SELECT ename
FROM emp
WHERE NOT EXISTS (SELECT NULL
FROM dept
WHERE dept.deptno = emp.deptno);

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is meant by an index?

1062

Can you have more than one content canvas view attached with a window ?

2266

What is format trigger?

2018

How to empty your oracle recycle bin?

983

Whats the benefit of dbms_stats over analyze?

1935

What are nested tables?

1107

How to connect to a remote server?

1057

What privilege is needed for a user to delete rows from tables in another schema?

1020

How to define a sub function?

1086

How to write text literals in oracle?

1021

What is oracle and what are its different editions?

1012

What is SQL access advisor in Oracle?

1139

What is a system tablespace and when it is created?

921

How to connect to the server with user account: sys?

973

What are the different types of modules in oracle forms?

953