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
Is it possible to split the print reviewer into more than one region ?
Explain the different normalization forms?
What is a trigger oracle?
How do I find my oracle client driver version?
Explain the use of constraints option in exp command.
What is backup in Oracle?
What is an oracle and why it is used?
What are the varoius components of physical database structure of oracle database?
How to convert a date to char in oracle? Give one example.
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
Difference between varchar and varchar2 data types?
Explain what are the different type of segments?
Why cursor variables are easier to use than cursors?
 How to use an oracle sequence generator in a mapping?
What are the differences between char and nchar in oracle?