Interested to Buy Any Domain ? << Click Here >> for more details...
What different of iner joint & outer joint with example
- 4 Answers
- 10037 Views
- I also Faced
- E-Mail Answers
Answer Posted / joel
inner join will select the record that are match only. it is
just like equi join. but outer join select the record not
only the equal one but also select the not equal one.
outer join is of three type namely
right outer,
left outer and
full outer.
1) right outer join will be like below in the join condition
e.deptno(+)=d.deptno.
that is it select all the uncommon values including common
values from the table e.
2)while left outer join will be like below in the join condition
e.deptno=d.deptno(+);
it will select uncommon values including common values
from table d.
3) full outer join is as like inner join. it will select
common values only
| Is This Answer Correct ? | 14 Yes | 6 No |
Post New Answer View All Answers
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
How index is implemented in oracle database?
What is the exact use of Collections?
What is a snapshot log?
Is there an oracle sql query that aggregates multiple rows into one row?
What privilege is needed for a user to query tables in another schema?
Explain an exception?
What are the various oracle database objects?
Differentiate between pre-select and pre-query?
Explain oracle left join with an example?
Explain an index segment?
What is the usage of merge statement?
What are the tools for Oracle ?
What is a select query statement in oracle?
material view and view disadvantages?
