Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Outer join and Full outer join?
- 5 Answers
- 40173 Views
- I also Faced
- E-Mail Answers
Answer Posted / sakshisree
Outer Join:
There are three types of outer joins namely:
Left Outer Join---For retreiving all the columns from the
first table irrespective of the column match.
Right Outer Join---For retreiving all the columns from the
second table irrespective of the column match
Full Outer Join---For retreiving all the columns from both
the tables irrespective of column match.
| Is This Answer Correct ? | 38 Yes | 12 No |
Post New Answer View All Answers
How do I use unicode codesets with the weblogic jdriver for oracle driver?
How to best split csv strings in oracle 9i?
What are the arithmetic operations?
What is not equal to in oracle?
Briefly explain what is literal? Give an example where it can be used?
How to delete a user account in oracle?
Give syntax for SQL and ORACLE joins.
What are transaction isolation levels supported by oracle?
What is a database table in oracle?
how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?
State and explain about oracle instance?
How would you best determine why your MVIEW couldnt FAST REFRESH?
How to use existing values in update statements using oracle?
What is difference between truncate and delete?
How to check the oracle tns settings?
