What is the difference between Outer join and Full outer join?

Answers were Sorted based on User's Feedback



What is the difference between Outer join and Full outer join?..

Answer / sakshisree

Outer Join:

There are three types of outer joins namely:
Left Outer Join---For retreiving all the columns from the
first table irrespective of the column match.
Right Outer Join---For retreiving all the columns from the
second table irrespective of the column match
Full Outer Join---For retreiving all the columns from both
the tables irrespective of column match.

Is This Answer Correct ?    38 Yes 12 No

What is the difference between Outer join and Full outer join?..

Answer / bukko

A join is between 2 tables (or views), for example:

TABLE1 <==> TABLE2

A LEFT OUTER JOIN returns all rows from the LEFT table (TABLE1 in the example) and only the rows from the RIGHT table (TABLE2) where the columns in the join clause match.

A RIGHT OUTER JOIN is, unsurprisingly, the same but reveresed, i.e. all rows from TABLE2 plus the rows from TABLE1 where the columns in the join clause match.

A FULL OUTER JOIN is both; it returns all rows which would result if it were a LEFT OUTER JOIN plus all the rows which would result if it were a RIGHT OUTER JOIN.

Is This Answer Correct ?    9 Yes 4 No

What is the difference between Outer join and Full outer join?..

Answer / syam kumar m

Left Outer Join---For retreiving all the columns from the
first table irrespective of the column match.
Right Outer Join---For retreiving all the columns from the
second table irrespective of the column match
Full Outer Join---it retrieves the matched data from the
two tables and affter shows remaining rows in the result
set like below example.
col_one col_two col_one col_two
---------------- ---------------------
1 a 2 B
2 b 3 C
3 c 4 D
full outer join
---------------
col_one col_two col_one col_two
2 b 2 B
3 c 3 C
- - 4 D
1 a - -

Is This Answer Correct ?    5 Yes 4 No

What is the difference between Outer join and Full outer join?..

Answer / pushpa g

in NON-ANSI syntax ,we have two types of outer joins,
those r 1. left outer join.
2. right outer join.
in ANSI syntax ,we have three types of joins.
1. left outer join.
2.right outer join.
3.full outer join.
in L.O.J. and R.O.J. we get only matched columns from both
the tables.
but in F.O.J. we can get matched+ unmatched data from
both the tables.

Is This Answer Correct ?    11 Yes 11 No

What is the difference between Outer join and Full outer join?..

Answer / a g srikanth

Amongh outer joins there are three types
1)Left outer join
2)Right outer join
3)Full outer join

Left outer join: In this join the (+) sign is given with
the table to the left of the equal to sign

i.e emp.deptid(+)=dept.deptid

here we are seeking blank columns from the left table i.e.
emp if no matching columns are there in the right table i.e
dept

Right outer join: In this join the (+) sign is given with
the table to the right of the equal to sign

i.e emp.deptid=dept.deptid (+)

here we are seeking blank columns from the right table i.e.
dept if no matching columns are there in the left table i.e
emp.

NOTE:scott.emp and dept values do not give any rows for
right outer joins, for right outer join, assume that there
is some employee in emp table who is not yet assigned any
department number.

Full outer join:in this type of join we force blanks if any
from both the tables

SELECT *
FROM emp
FULL OUTER JOIN dept
ON emp.Deptid = dept.Deptid

Is This Answer Correct ?    5 Yes 6 No

Post New Answer

More Oracle General Interview Questions

what are the diffeenes between oracle 9i,oracle 10g

2 Answers  


How to add another datafile to a tablespace?

0 Answers  


How to login to the server without an instance?

0 Answers  


What are the different pseudo commands? Explain in general?

0 Answers  


How to use "if" statements on multiple conditions?

0 Answers  






What is Row Chaining ?

3 Answers   Cognizant, CTS,


Explain the use of online redo log files in oracle.

0 Answers  


How to create a temporary table in oracle?

0 Answers  


When a form is invoked with call_form, Does oracle forms issues a save point ?

1 Answers   Oracle,


How to convert numbers to characters in oracle?

0 Answers  


How to Truncate Table in Oracle

0 Answers   HCL,


How to bring a tablespace offline?

0 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)