What is a OUTER JOIN?
- 1 Answers
- 2235 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 |
how do u know the total no of rows in a table?
what is the syntax of ALTER command?
How data locks are respected in oracle?
How to drop an index?
How to shutdown your 10g xe server from command line?
What is rich query?
How do I uninstall oracle 11g?
What are the differences between char and varchar2 in oracle?
What is translate in oracle?
what is RAID technology?which is better RAID 0+1 OR RAID 5?
What is an oracle wallet?
What do you mean by a deadlock?
Oracle General 
