various types of joins
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 Java Pool in Oracle?
Create table Employee ( Employee_Id varchar2(8) Constraint emp_id_pk primary key, FirstName varchar2(50), LastName varchar2(50), DeptID Number(5) Constraint dept_id_fk Foreign Key(DeptId) References Department(DeptId) ) Error I am getting: Constraint specification are not allowed here
Explain the use of file option in exp command.
You create a private database link and upon connection, fails with: ORA-2085: connects to . What is the problem? How would you go about resolving this error?
When do you get a .pll extension in oracle?
sql command 2 know current database
what is primary key and foreign key when and where have to use
What are the factors causing the reparsing of SQL statements in SGA?
find out the third highest salary?
92 Answers CIPL, Cyber Shot, HCL, Hewitt, IBM, JPMorgan Chase, Orion, Verizon,
In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?
Is oracle a relational database?
Explain the use of control file?