Interested to Buy Any Domain ? << Click Here >> for more details...
various types of joins
- 9 Answers
- 9945 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 |
What is instant client oracle?
Explain about integrity constraint?
How to write a query with a right outer join in oracle?
I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.
How to resolve name conflicts between variables and columns?
When system tablespace is created?
which statement is running fastly ie insert or delete?
please explain.. DB architecture ...
What is the CAP theorem?
How to assign values to variables?
Preparing for Oracle PL/SQL Interviews – Need Help with Common Questions
What is DTS and purpose of DTS ?
Oracle General 
