Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Outer join and Full outer join?
- 5 Answers
- 40207 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 to drop an index in oracle?
What is the relationship among database, tablespace and data file?
How can we force the database to use the user specified rollback segment?
What is instant client oracle?
Can we call procedure inside function in oracle?
How to delete multiple rows from a table in oracle?
What is bulk collect in oracle?
How to install oracle odbc drivers?
What are the general rules on data consistency?
How to use group functions in the select clause using oracle?
How to resolve name conflicts between variables and columns?
How to define an anonymous block?
Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?
What are the differences between lov and list item?
What happens to indexes if you drop a table?
