Answer Posted / syam kumar m

Left Outer Join---For retreiving all the columns from the
first table irrespective of the column match.
Right Outer Join---For retreiving all the columns from the
second table irrespective of the column match
Full Outer Join---it retrieves the matched data from the
two tables and affter shows remaining rows in the result
set like below example.
col_one col_two col_one col_two
---------------- ---------------------
1 a 2 B
2 b 3 C
3 c 4 D
full outer join
---------------
col_one col_two col_one col_two
2 b 2 B
3 c 3 C
- - 4 D
1 a - -

How many categories of data types?

985

---

Difference between the “verify” and “feedback” command?

1358

---

I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.

2305

---

Explain what are the different type of segments?

955

---

How do we get field detail of a table?

1071

---

How to use in conditions in oracle?

1046

---

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.

2179

---

Is there a function to split a string in plsql?

1047

---

Explain oracle insert into command?

1107

---

Can I create users through internet explorer in oracle 10g?

1075

---

Briefly explain what is literal? Give an example where it can be used?

1022

---

What are the predefined tablespaces in a database?

1077

---

How do I spool in oracle?

998

---

How to drop a stored procedure in oracle?

1049

---

What are the differences between interval year to month and interval day to second?

1020

---