Interested to Buy Any Domain ? << Click Here >> for more details...
various types of joins
- 9 Answers
- 10332 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Generally there are five types of joins in oracle:
Self Join
Equi Join
Cartesian Join
Outer Join(Left outer join,Right outer join)
Non_Equi JOin
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / s. senthil kumar
There are Two Types of joins:
I. Inner Join
II. Outer Join
I: Inner join:a) Equi join, b) Non Equi join c) self join
II: Outer join: a) Left outer join, b) right outer join,
c) Full outer join
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / kumar
Types of joins are :
Equi-Join
Non-Equi-Join
Right Outer Join
Left Outer Join
Full Outer Join
Self Join
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / shankar
1. Equi Join
2. Non-Equi join
3. Outer Join
4. Self Join
| Is This Answer Correct ? | 2 Yes | 2 No |
Joins-------------------- We have
Equi join,
Non-Equi Join,
Outer Join,
Self Join,
Cartesian Join.
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / anjum
There are four types of joins
Inner join (Equi join,Non Equi join)
Outer join (Left outer, Right outer,Full outer)
Self join
Cartesian join
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / vikash kumar gupta
basically three type of join.
inner join,outer join,Cartesian join or product join
| Is This Answer Correct ? | 0 Yes | 0 No |
Why use resource manager in Oracle?
what are steps for interface? where is exchange rate defined in which table?
Can we save images in a database and if yes, how?
What does a Control file Contain ?
Oracle
0 Answers ABC, Genpact, HUI, Oracle,
What is the max number of columns in an oracle table?
where we have to use ON clause and where we have to use USING clause in JOINS
What is a materialised view?
List the various oracle database objects?
How to add a new column to an existing table with a default value?
What is SQL access advisor in Oracle?
What is a subquery?
Oracle General 
