Answer / mahima

Inner join: displays only matching record from 2 tables
Outer join:
Left outer join display all the records from 1st table even
if dont have matching record in 2nd table
rignt outer join display all the record from the 2nd table
even if there is not matching record in 1st table

Answer / vamsi krishna

INNER JOIN DISPLAYS ONLY THE RECORDS WHICH ARE SATISFYING
THE JOINING CONDITION,WHERE AS IN AN OUTER JOIN IT DISPLAYS
THE RECORDS WHICH ARE SATISFYING THE CONDITION AND ALSO
WHICH ARE NOT SATIFYING THE CONDITION ALSO.
FOR EXAMPLE TAKE EMP AND DEPT TABLE.
INNER JOIN QUERY:
SELECT EMPNO,ENAME,SAL,DEPT.DEPTNO,DNAME,LOC FROM EMP INNER
JOIN DEPT ON(EMP.DEPTNO=DEPT.DEPTNO)
OUTER JOIN QUERY:
SELECT EMPNO,ENAME,SAL,DEPT.DEPTNO,DNAME,LOC FROM EMP RIGHT
OUTER JOIN DEPT ON(EMP.DEPTNO=DEPT.DEPTNO).
IN INNER JOIN IT DISPLAYS ONLY 10,20 & 30 DEPARTMENTS.
IN OUTER JOIN IT DISPLAYS 10,20,30 AND 40 DEPARTMENTS.
TAKE DEFAULT TABLES FOR EXECUTION

Answer / khalek

In Inner Join Only Matching Records come while in Outer Join
All Matching Records + All Non Matching Record(Based on
Outer Join type).

Outer join may be any type from following.
1) Left Outer Join
2) Right Outer Join
3) Full Outer Join

You can see full detail at
<a
href="http://interview-preparation-for-you.blogspot.com/2010/11/difference-between-inner-joinouter-join.html">http://interview-preparation-for-you.blogspot.com/2010/11/difference-between-inner-joinouter-join.html</a>

Answer / sunny

Inner join means it display all matching records in both tables depends upon condition....

Outer joins are three types..
1.left outer
2.right outer
3.full outer

In left outer:it will display all columns of right side table and matching columns of both tables.

In right outer:it will display all columns of left side table and matching columns of both tables.

In full outer:all matching non matching columns of both tables are displayed.

Answer / 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

Answer / sripathi venkata ramesh

I am Sripathi Venkata Ramesh from Gudivada

Answer is below

Joins

a) Inner join or default join or Equi Join:
It selects all the matching aswellas non matching records
from both the tables.

b) Outer join: It selects all the matching
aswellas non matching records from both the tables
depending upon the join type.

1) Left outer join:
It selects all the records from the left table but only the
matching records from the right table.

2) Right outer join: It
selects all the records from the right table but only the
matching records from the left table.

3) Full outer join:
It’s a union of left and right outer join.

c) Cross join or Cartesian join: Every row
in the first table joins with every row in the second
table. It does not have any condition. It is also called as
a Cartesian join.

d) Self join: Joining a table by itself is
called Self join. Here we have to use alias table.

How to find out what privileges a user currently has in oracle?

1 Answers  

What is mean by Program Global Area (PGA) ?

9 Answers   Bajaj,

What is a partition in oracle?

0 Answers  

Explain oracle instance.

0 Answers  

Create table Employee ( Employee_Id varchar2(8) Constraint emp_id_pk primary key, FirstName varchar2(50), LastName varchar2(50), DeptID Number(5) Constraint dept_id_fk Foreign Key(DeptId) References Department(DeptId) ) Error I am getting: Constraint specification are not allowed here

2 Answers  

what is the difference between substr and instr function in oracle?

0 Answers  

How do I use os authentication with weblogic jdriver for oracle and connection pools?

0 Answers  

How to create an oracle testing table?

0 Answers  

HOW TO CONVERT ORACLE TABLE DATA (RECORDS)INTO EXCEL SHEEET?

3 Answers  

Which are the five query types available in oracle?

0 Answers  

What is the data type of dual table?

0 Answers  

Can a primary key contain more than one columns?

2 Answers