There are three tables :
E : EID,ENAME
D : DID,DNAME
empdept : eid, did


select the employees who doesn't belong to any dep

Answers were Sorted based on User's Feedback



There are three tables : E : EID,ENAME D : DID,DNAME empdept : eid, did select the employees..

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

There are three tables : E : EID,ENAME D : DID,DNAME empdept : eid, did select the employees..

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

There are three tables : E : EID,ENAME D : DID,DNAME empdept : eid, did select the employees..

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

There are three tables : E : EID,ENAME D : DID,DNAME empdept : eid, did select the employees..

Answer / ajit

select e.eid, e.ename
from E e, D d
where e.eid = d.did(+)
and d.did is null;

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle General Interview Questions

Can a primary key contain more than one columns?

2 Answers  


when i run my query on yesterday it is fast but today it is slow why?

1 Answers  


How to delete a column in an existing table in oracle?

0 Answers  


how to we delete a row using varray

3 Answers   CTC,


how to find find & delete duplicate rows from two different tables?

3 Answers   Accenture, TCS,






Explain the use of tables option in exp command.

0 Answers  


How to define default values for formal parameters?

0 Answers  


What are joins, explain all types of joins?

0 Answers   Bravura Solutions,


Explain the use of inctype option in exp command.

0 Answers  


How to use "while" statements in oracle?

0 Answers  


Differentiate between function and procedure in oracle.

0 Answers  


interview questions with answer for cts

0 Answers   Cognizant,


Categories
  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)