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 the use of inctype option in exp command.

1034

---

What is the difference between substr & instr functions?

1228

---

How will you write a query to get a 5th rank student from a table student_report?

1866

---

What is Virtual Private Database in Oracle?

1091

---

How to use null as conditions in oracle?

1084

---

Difference between varchar and varchar2 data types?

1185

---

How to loop through data rows in the implicit cursor?

1074

---

How to commit the current transaction in oracle?

1120

---

How to define an anonymous block?

1158

---

how can we store any pdf file in oracle

2164

---

What are the varoius components of physical database structure of oracle database?

1006

---

what is the difference between substr and instr function in oracle?

1090

---

How to use subqueries in the from clause in oracle?

1113

---

6. Display the client name and order date for all orders using the traditional method.

2308

---

If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?

2292

---