Interested to Buy Any Domain ? << Click Here >> for more details...
What is a OUTER JOIN?
- 1 Answers
- 2875 Views
- I also Faced
- E-Mail Answers
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 the uses of synonyms?
Explain the concept of the DUAL table.
What is recovery manager(rman) backup in Oracle?
Explain the difference between a procedure and a function?
What is an Integrity Constrains ?
T1: T2 A X--- this is updated record B B like this T1 table having no.of records updated. write a query"retrive updated record from T2"
What are the uses of Database Trigger ?
Explain the family trees and connection by clause
which is best institue to learn oracle 11i in ameerpet or maithrivanam or sr nagar please help
How can we find out the duplicate values in an oracle table?
Does facebook use oracle?
What is materialized view in Oracle?
Oracle General 
