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 load data from external tables to regular tables?
What are the different types of trigger and explain its various uses and functions?
Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?
What is the data pump import utility?
How to retrieve data from an explicit cursor?
What are transaction isolation levels supported by oracle?
What is raw datatype in oracle?
How to work with data objects interactively?
Can multiple cursors being opened at the same time?
hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.
What is Reduced List of Values?
What is an oracle database table?
21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.
How would you change old and new values in an insert, delete and update triggers?
HI, Please let me know the syllabus for Oracle OCA and OCP Certification