What is a OUTER JOIN?
- 1 Answers
- 2089 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 |
Differnce between view and index
What are data pump export and import modes?
i have procedure p1.and also i declare the same procedure in a package. whice one is efficient package procedure or procedure?
How to write a query with a right outer join in oracle?
How to omit columns with default values in insert statement in oracle?
How to insert a new row into a table in oracle?
HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.
how to find full database size
1 Answers BirlaSoft, Consultancy,
Why oracle is used?
Why do we use coalesce function in oracle?
How to use subqueries with the in operator using oracle?
1. How actually index will work ? 2. Why do people prefer mostly bitmap index and btree index in datawarehouse ? 3. If I use the column in aggrigate functions like max,min,count and avg and if I have a index created on that column, will it increases the performance ?
Oracle General 
