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 - -

What happens if variable names collide with table/column names?

1262

---

Can group functions be used in the order by clause in oracle?

1040

---

what is reindexing?

1725

---

How many types of segments in Oracle?

1114

---

How do you find current date and time in oracle?

1096

---

Can we protect our pl/sql source code?

1079

---

How do I call oracle stored procedures that take no parameters?

1193

---

why dont we assign not null constraint as table level constraint.

2793

---

How to rename a column in an existing table?

1081

---

How to create an oracle testing table?

1126

---

How to define an external table with a text file?

1120

---

Can sub procedure/function be called recursively?

1043

---

Why does for update in oracle 8 cause an ora-01002 error?

1043

---

What are the differences between date and timestamp in oracle?

1093

---

What is the purpose of tables, private synonyms and public synonyms in Oracle?

1089

---