What is the difference between Outer join and Full outer join?
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 open a cursor variable?
Can you have more than one content canvas view attached with a window ?
What is the disadvantage of User defind function?
How to use subqueries with the in operator using oracle?
How to view the tablespaces in the current database?
How to assign values to variables?
What is an oracle function?
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
What is a subquery?
What is a oracle database?
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?
How to establish administrator authentication to the server?
What are the oracle differences between nvl and coalesce
Is postgres faster than oracle?
Can we store pictures in the database and if so, how it can be done?