Answer / parthasarathi

outer join is used to fetch unmatched records along with matched records..

there are 3 kinds of outer joins available.

1.Left outer join :- used to fetch unmatched records at left side table.

2.right outer join :- used to fetch unmatched records at right side table.

3.Full outer join :- used to fetch unmatched records at both side tables.

find the second highest salary of the emp table

6 Answers  

---

How do I connect to oracle?

0 Answers  

---

How to load data through external tables?

0 Answers  

---

how can db_files > maxdatafiles since db_files is for instance and the later is for database

0 Answers   CTS,

---

What are the factors that affect OPTIMIZER in choosing an Optimization approach ?

2 Answers  

---

5. Display full details for the creditor/s who has received the single largest payment. Do not use a table join or set operator anywhere in your query.

6 Answers   Wipro,

---

Explain the use of file option in exp command.

0 Answers  

---

What is a sub query? Describe its types?

0 Answers  

---

Hi Every One , What is the table Space in Oracle Database ? waiting for answere and thankyou

8 Answers  

---

 How to use an oracle sequence generator in a mapping?

0 Answers   Informatica,

---

Hi all, Can any one give answer for this question. Suppose im having employee table with fields, eno, ename, dept, address1, address2, address3. In address field employee can fill only address1 or address2 or address3... at a time he can fill three address fields. now i want all employee names who filled only one address field.. Plz its urjent can any one give querry.. Thanks in advance.

4 Answers   JPMorgan Chase,

---

1.What is inline function in oracle and its purpose? 2.What is the equivalent operator for "different from pattern" in oracle? 3. If you define a variable in oracle, how it will be available? [a. Until database shut down b. Until table deleted c. until session get expired]

2 Answers  

---