SELECT E.ENAME FROM EMPLOYEE E WHERE E.EID IN (SELECT EID FROM EMPDEPT WH

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

Answer Posted / neha_gupta

SELECT E.ENAME FROM EMPLOYEE E WHERE E.EID IN (SELECT EID
FROM EMPDEPT WHERE DID IS NULL)

Is This Answer Correct ?

5 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What are the differences between char and varchar2 in oracle?

556

Is a rollback possible to any savepoint?

550

What are the attributes of cursor?

581

How many types of auditing in Oracle?

559

What is the difference between "as" and "is" in an oracle stored procedure?

532

Explain drop constraint oracle?

589

How to write text literals in oracle?

602

How to loop through data rows in the implicit cursor?

537

you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz

1553

What are a query and state the different types of queries and their uses?

506

Does oracle partitioning improve performance?

542

How much memory your 10g xe server is using?

577

How to load data from external tables to regular tables?

530

How to add another datafile to a tablespace?

570

How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

1430