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

How to delete all rows a table in oracle?

623

Explain what does a control file contain?

610

Does oracle partitioning improve performance?

552

How to load a large xml file?

586

What is raw datatype?

595

What are internal user account in oracle?

571

How to define an anonymous procedure without variables?

553

Use of an integrity constraint is better to validate data. Explain

547

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

1661

How to define a cusotmer as a supplier in ORACLE R12

1728

Explain what are the type of synonyms?

582

Point the difference between translate and replace?

572

How to add a new column to an existing table in oracle?

588

nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls

1745

What will be the syntax to find current date and time in format "yyyy-mm-dd"?

570