What are joins..how many types of joins are there?
- 29 Answers
- 76668 Views
- Amdocs, CSC, TCS, I also Faced
- E-Mail Answers
Answer Posted / rama mohan reddy
ACTUALLY PRIOR 8i THERE ARE 4 TYPES OF JOINS ARE THERE THEY ARE
1. EQUI JOIN
2. NON EQUIJOIN
3. SELF JOIN
4. OUTER JOIN
A) LEFT OUTER JOIN
B) RIHT OUTER JOIN
BUT ANSI PROIDES NEW JOINS FROM 1999 THEY ARE
1. CROSS JOIN
2. NATURAL JOIN
3. USING CLAUSE
4. INNER JOIN //SAME AS EQUI JOIN PRIOR 1999
5. SELF JOIN //SAME AS SELF JOIN PRIOR 1999
6. RIHT OUTER JOIN
7. LEFT OUTER JOIN
8.FULL OUTER JOIN
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
 What are the oracle DML commands possible through an update strategy?
How to name query output columns in oracle?
Which environment variables are absolutely critical in order to run the OUI?
can u send the sql dumps to sivakumarr1987@gmail.com plz help me
Can we protect our pl/sql source code?
How to check the oracle tns settings?
Give the various rollback segment states.
Respected sir, Please send me technical questions related to oracle apps..
Is insert autocommit in oracle?
what is a Nested Loop join?
Explain oracle data types with examples?
Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.
What happens to indexes if you drop a table?
How to drop a stored procedure in oracle?
Explain the use of inctype option in exp command.
