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
What the is the diff between local index and global index. give some example.
How to assign data of the deleted row to variables?
What is a table index?
How to create lov dynamically at runtime & attach to text field?
Is there a combination of "like" and "in" in sql?
What are the oracle built-in data types?
What are the limitations of check constraint?
What are nested tables?
how can we store any pdf file in oracle
How to get the Installed Oracle Version Information ?
Does oracle database need java?
Explain a data segment?
What is the difference between $oracle_base and $oracle_home?
Describe varray?
There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??