Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Outer join and Full outer join?
- 5 Answers
- 40035 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
How to do a full database export?
Can we connect to ORACLE db using Windows Authentication?
How to best split csv strings in oracle 9i?
Give the advantages and disadvantages of clusters.
hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.
What is an Oracle index?
How to get a list of all background sessions in the database?
How do we get field details of a table?
How to work with data objects interactively?
What is rich query?
How to apply filtering criteria at group level in oracle?
How do I uninstall oracle client from windows?
What is the difference between view and materialized view in Oracle?
Is there a combination of "like" and "in" in sql?
what is the use of triggers in Java program? I mean where do we use triggers in Java programming?
