Answer Posted / joel

inner join will select the record that are match only. it is
just like equi join. but outer join select the record not
only the equal one but also select the not equal one.

outer join is of three type namely
right outer,
left outer and
full outer.

1) right outer join will be like below in the join condition

e.deptno(+)=d.deptno.

that is it select all the uncommon values including common
values from the table e.


2)while left outer join will be like below in the join condition

e.deptno=d.deptno(+);

it will select uncommon values including common values
from table d.


3) full outer join is as like inner join. it will select
common values only

What are the different pseudo commands? Explain in general?

1125

---

How to call a stored function with parameters?

1095

---

Can you drop an index associated with a unique or primary key constraint?

1069

---

Is it possible to insert comments into sql statements return in the data model editor ?

2638

---

Hi friends can u send the oracle 9i full version download link?????????????? please reply ?

1924

---

Explain how are indexes update?

1123

---

What is private procedure oracle?

1050

---

what happened to the global index when I truncate the data in one of the partition?

2066

---

How to define a variable to match a table column data type?

1038

---

What is a snapshot in oracle database?

1073

---

What is bulk load in oracle?

1130

---

How to upsert (update or insert into a table)?

1044

---

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.

2247

---

If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?

2336

---

Difference between inner join vs where ?

1096

---