What is the difference between Outer join and Full outer join?
- 5 Answers
- 38136 Views
- I also Faced
- E-Mail Answers
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
types of indexes and the rationale behind choosing a particular index for a situation.
How to create additional tablespaces for an new database?
Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?
How to run queries on external tables?
What is the disadvantage of User defind function?
What is object data modeling?
Is oracle the best database?
How to define a variable to match a table column data type?
How many categories of data types?
What is meant by an index?
Which environment variables are absolutely critical in order to run the OUI?
What is the maximum limit on the number of columns in a table?
How to get a create statement for an existing table?
What is the difference between substr & instr functions?
What are temporal data types in oracle?
