What is a OUTER JOIN?
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.
Is This Answer Correct ? | 3 Yes | 0 No |
what are steps for interface? where is exchange rate defined in which table?
How do I limit the number of rows returned by an oracle query after ordering?
Explain an exception?
What are oracle functions?
find out first highest salary?
10 Answers Verinon Technology Solutions,
pls explain connect by prior with example and its real time use
what is the exact definition for pointer?
Explain drop constraint oracle?
What is define in oracle?
What is a initialization parameter file in oracle?
What is the effect of setting the 'RULE' for OPTIMIER_GOAL parameter of the ALTER SESSION Command ?
what is the syntax of UPDATE command?