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 is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
What is SAVE POINT ?
Compare and contrast between sql and sql server and explain its various functions?
Can multiple cursors being opened at the same time?
What is the usage of merge statement?
What is tns entry?
What are operators in oracle?
Can we create trigger on materialized view in oracle?
What is Data Block ?
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 ?
Explain what are clusters?
Explain the use of grant option in exp command.