What is the difference between Outer join and Full outer join?
Answer Posted / pushpa g
in NON-ANSI syntax ,we have two types of outer joins,
those r 1. left outer join.
2. right outer join.
in ANSI syntax ,we have three types of joins.
1. left outer join.
2.right outer join.
3.full outer join.
in L.O.J. and R.O.J. we get only matched columns from both
the tables.
but in F.O.J. we can get matched+ unmatched data from
both the tables.
| Is This Answer Correct ? | 11 Yes | 11 No |
Post New Answer View All Answers
What are the types of partitions in oracle?
How would you best determine why your MVIEW couldnt FAST REFRESH?
What are the differences between blob and clob in oracle?
Can we use oracle pl/sql block in core java? if so how? pls get back to me .....
What are the set operators union, union all, minus & intersect meant to do?
what is the dual table in oracle?
How to update values on multiple rows in oracle?
Hi friends can u send the oracle 9i full version download link?????????????? please reply ?
How to install oracle database 10g xe?
List the various oracle database objects?
How to create an initialization parameter file?
Briefly explain what is literal? Give an example where it can be used?
What is the usage of control file in oracle?
How to use fetch statement in a loop?
Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..