There are three tables :
E : EID,ENAME
D : DID,DNAME
empdept : eid, did
select the employees who doesn't belong to any dep
Answer Posted / 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 View All Answers
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.
What are the limitations oracle database 10g xe?
Explain compound trigger in oracle?
What is SQL access advisor in Oracle?
What are the various types of snapshots ?
How to loop through a cursor variable?
We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.
what are steps for interface? where is exchange rate defined in which table?
What is meant by recursive hints in oracle?
What is data type in oracle?
How to calculate date and time differences in oracle?
What is memory advisor in Oracle?
How to apply filtering criteria at group level in oracle?
How to get execution path reports on query statements?
How to get last row id?