Please explain the difference between outer join and inner
join? With examples would be appreciable..!
Answer Posted / ashish sajwan
In Inner join the result is show only the matching columns which are common in both tables,In outer join the results show matched and unmatched columns from both tables
| Is This Answer Correct ? | 3 Yes | 4 No |
Post New Answer View All Answers
How to open a cursor variable?
What is transaction control statement and how many types of transaction control statement in Oracle?
What are the differences between primary key and unique key?
What are the varoius components of physical database structure of oracle database?
What are advantages of dateset in datastage?
How to login to the server without an instance?
what is dynamic SGA and static SGA
What is system global area (sga) in oracle?
Is truncate autocommit in oracle?
What is a dynamic performance view in oracle?
Hi Can any one tell me what are the API's used in requisition import.
What is where clause in oracle?
How to use "in out" parameter properly?
Explain oracle’s system global area (sga).
How to add a new column to an existing table in oracle?