SQL Plus - How many types of joins are there in oracle and what are the difference between them

GeekInterview.com > Interview Questions > Oracle > SQL Plus

Go To First | Previous Question | Next Question

SQL Plus | Question 115 of 132

How many types of joins are there in oracle and what are the difference between them

Total Answers and Comments: 8

Last Update: June 07, 2008 Asked by: rekha

Sponsored Links

Best Rated Answer

—

Submitted by: kamal

There are 4 types of joins

equi join

non equi join

outer join

self join

Above answer was rated as good by the following members:
mans_1201, guia marie, vishakha_jain81

October 09, 2006 08:47:04

kamal

RE: How many types of joins are there in oracle and wh...

There are 4 types of joins

equi join

non equi join

outer join

self join

Is this answer useful? Yes | No

1 0

Overall Rating: +1

October 11, 2006 10:35:23

deepak Bhardwaj

RE: How many types of joins are there in oracle and wh...

In Oracle 9i there are two types of oracle join syntax

1.Oracle9i join syntax

2.SQL1999 join syntax

1.Oracle 9i join syntax have four type of joining

a Equi join

b.Non-equi Join

c.Self Join

d. Outer join

e.Curtision products

2.Sql 1999 join syntax have following join types

Natural Join

Cross-join

Using-on

using-with

inner join

Outer join

there is no functionality difference between Oracle9i join syntax and SQL1999 join syntax.They have only syntax difference

Is this answer useful? Yes | No

1 0

Overall Rating: +1

October 19, 2006 00:54:27

Srikanth

RE: How many types of joins are there in oracle and wh...

HI Diffferent types of join Natural Joinequi joinNonequi joinCross-joininner joinOuter joinLeft joinright Join

Is this answer useful? Yes | No

November 08, 2006 05:24:49

sujana

RE: How many types of joins are there in oracle and wh...

equi joins

non equi joins

outer joins

self joins

vertical joins

Is this answer useful? Yes | No

November 20, 2006 03:39:52

Debi Prasad Maharana,Wipro Technologies.

RE: How many types of joins are there in oracle and wh...

Different type of joinEqui join - when you have a common attribute between two tables.Non Equi join - when you have a common relationship between two tables.Self join - when you want to join the table with itself.Equi join is again have different type(1) inner join(2) outer joinAll the join can be written in two standard format(1) in oracle standard format(2) in ANSI standard formatin ANSI standard format (keywords)(1) natural [inner] join(2)inner join...using(3)inner join...on(4)left outer join(5)right outer join

Is this answer useful? Yes | No

June 24, 2007 04:08:02

singh.mandeep

Member Since: June 2007 Contribution: 4

RE: How many types of joins are there in oracle and wh...

Below listed types of Joins are present in Oracle (8i and prior)

1. Equi
Joins

2. Non-Equi Joins
3. Outer Joins
4. Inner Joins

SQL :1999 Compliant joins are

1.
Cross joins
2. Natural joins
3. Using clause
4. Full or two sided outer joins

5. Arbitrary join conditions for outer joins

Is this answer useful? Yes | No

1 0

Overall Rating: +1

May 13, 2008 02:36:01

nalls_indian

Member Since: February 2008 Contribution: 1

How many types of joins are there in oracle and what are the difference between them

How many types of joins are there in oracle and what are the difference between them

Is this answer useful? Yes | No

June 07, 2008 12:35:50

mans_1201

Member Since: June 2008 Contribution: 1

RE: How many types of joins are there in oracle and what are the difference between them

There are four Type of joins in oracle

1. Inner join
2.cartision join
3.self join
4. outer join

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank