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 is ordinary table in oracle?

643

---

What is a partition in oracle?

537

---

What do you mean by merge in oracle and how can we merge two tables?

569

---

What are the set operators union, union all, minus & intersect meant to do?

554

---

If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...

1726

---

---

How to write numeric literals in oracle?

599

---

How to use "startup" command to start default instance?

533

---

What is sharded cluster?

514

---

State and explain about oracle instance?

535

---

How can I get column names from a table in oracle?

526

---

What are the different types of trigger and explain its various uses and functions?

540

---

What are dml statements in oracle?

609

---

How to use select statement to count the number of rows in oracle?

545

---

What is the quickest way to fetch the data from a table?

557

---

Explain how you would restore a database using RMAN to Point in Time?

1621

---