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

Explain overloading. Can functions be overloaded?

938

---

How to sort output in descending order in oracle?

989

---

What is null value in oracle?

1037

---

What is data block in Oracle?

1052

---

What is oracle in java?

913

---

How to get last row id?

941

---

What is backup in Oracle?

952

---

How to write a query with an inner join in oracle?

976

---

What is procedure overloading in oracle?

994

---

What are the differences between number and binary_float in oracle?

1057

---

What are the attributes of the cursor?

938

---

What is the difference between hot backup and cold backup in oracle?

960

---

Explain a private synonyms?

984

---

What are the differences between primary key and unique key?

949

---

Can group functions be mixed with non-group selection fields?

965

---