Please explain the difference between outer join and inner
join? With examples would be appreciable..!
Answer Posted / khalek
In Inner Join Only Matching Records come while in Outer Join
All Matching Records + All Non Matching Record(Based on
Outer Join type).
Outer join may be any type from following.
1) Left Outer Join
2) Right Outer Join
3) Full Outer Join
You can see full detail at
<a
href="http://interview-preparation-for-you.blogspot.com/2010/11/difference-between-inner-joinouter-join.html">http://interview-preparation-for-you.blogspot.com/2010/11/difference-between-inner-joinouter-join.html</a>
| Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
What privilege is needed for a user to create tables in oracle?
Explain about functional dependency and its relation with table design?
Explain oracle 12c new features for developers?
Explain view?
src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));
What are the numeric comparison operations?
How to create an oracle database manually?
what is dynamic SGA and static SGA
Explain the types of exception?
Explain cascading triggers.
What is oracle host variable?
What is raw datatype in oracle?
How to view all columns in an existing table?
List out the components of logical database structure of oracle database.
How to define a data source name (dsn) in odbc manager?