Interested to Buy Any Domain ? << Click Here >> for more details...
What are joins..how many types of joins are there?
- 29 Answers
- 98086 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
Explain the use of constraints option in exp command.
What is the difference between "as" and "is" in an oracle stored procedure?
What is the data type of dual table?
State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.
What are triggers in oracle?
Compare and contrast between sql and sql server and explain its various functions?
How to manage transaction isolation level?
Can you tell me how to add new column in existing views?how?How is possible?
How to assign query results to variables?
What happens if the imported table already exists?
How to download oracle database 10g xe?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
How many anonymous blocks can be defined?
How to handle a single quote in oracle sql?
How do you bind variables in oracle?
