Interested to Buy Any Domain ? << Click Here >> for more details...
various types of joins
- 9 Answers
- 10331 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 |
Is oracle a relational database?
Please explain compound trigger in oracle?
We have one Package(which has many function/procedures, SQL quires etc). Now we need to check, which query or procedure is taking lot of time in that Package. ? How do we do it.
What is execute immediate in oracle?
how to we delete a row using varray
How many types of auditing in Oracle?
What is a cursor and what are the steps need to be taken?
What is the use of Redo Log Information ?
In which language oracle has been developed?
Display Odd/ Even number of records?
what is normalisation?what are its uses?
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
Oracle General 
