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
What happens in oracle commit?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
How to insert multiple rows with one insert statement in oracle?
How to turn on or off recycle bin for the session?
Can you have more than one content canvas view attached with a window ?
Can multiple cursors being opened at the same time?
How to fetch the row which has the max value for a column?
How to pass parameters to procedures in oracle?
How different is ms access and oracle?
What are the limitations of check constraint?
How to concatenate two text values in oracle?
What is Redo Log Buffer in Oracle?
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.