Interested to Buy Any Domain ? << Click Here >> for more details...
various types of joins
- 9 Answers
- 10039 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 |
How to Identify the previously inserted/updated records in already populated table.
What is tns name?
I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database
The table has 3 columns 4 rows. The output is which column has least null values( A COL SHOULD BE THE OUTPUT) Write the query plz. A B C ================ 1 NULL 2 NULL 3 4 NULL 5 6 7 NULL NULL O/P C = 2 4 6
what is the difference between primary key & foreign key?
57 Answers CTS, Infosys, La Multi, Sparsh, Wipro,
Differentiate between translate and replace?
How to specify default values in insert statement using oracle?
What is the use of Redo Log Information ?
How to convert character types to numeric types?
How to delete all rows a table in oracle?
What are temporal data types in oracle?
What are the different types of record groups in oracle? Explain each of them
Oracle General 
