There are three tables :
E : EID,ENAME
D : DID,DNAME
empdept : eid, did
select the employees who doesn't belong to any dep
- 4 Answers
- 6578 Views
- Microsoft, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
what is reindexing?
What to do if the binary spfile is wrong for the default instance?
Explain the use of parfile option in exp command.
Write a trigger example in oracle?
How to connect asp pages to oracle servers?
How to load data from external tables to regular tables?
How do I know if oracle client is installed on windows?
What is oracle database client?
I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.
Can you create a synonym without having a table?
What is a directory object?
How to write numeric literals in oracle?
What is a oracle database?
Can we store pictures in the database and if so, how it can be done?
Explain a data segment?
