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 open database communication (odbc) in oracle?

987

---

What is the sql query to concatenate column values from multiple rows in oracle?

1034

---

candidate key is subset of super key but not vice-verse explain

2056

---

How to get execution path reports on query statements?

964

---

How to start a specific oracle instance?

1014

---

what is insert all statement in sql

6478

---

What is varray?

1107

---

How to define an external table with a text file?

1045

---

What is the difference between I and G in Oracle?

1076

---

Is oracle the best database?

944

---

What is transport network substrate (tns) in oracle?

1029

---

Explain the use of file option in exp command.

1114

---

How to revoke create session privilege from a user in oracle?

997

---

what is reindexing?

1647

---

How to get last row id?

970

---