What is a OUTER JOIN?
- 1 Answers
- 2081 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 |
create one table to capture an employee details with a primary key.
Differnce between view and index
Which database is better for os platform dependency?
How to put more than 1000 values into an oracle in clause?
what is the difference between table and veiw?
Explain drop constraint oracle?
What is the disadvantage of User defind function?
How do you increase the OS limitation for open files (LINUX and/or Solaris)?
what is the use of triggers in Java program? I mean where do we use triggers in Java programming?
Does a Before form trigger fire when the parameter form is suppressed ?
what is the scenario where you take the database to NoArchivelog mode?
what is load balancing and what u have used to do this?(sql loader)
Oracle General 
