What are joins..how many types of joins are there?
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
How to write a query with a right outer join in oracle?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
Can we use oracle pl/sql block in core java? if so how? pls get back to me .....
Difference between pre-select and pre-query
What is an oracle and why it is used?
How to convert character types to numeric types?
How to drop an index?
Explain the different normalization forms?
What is snapshot is too old? Give and example for better understand.
What is a view and how is it different from a table?
How to call a stored function with parameters?
Is there any function in oracle similar like group_concat of mysql?
How do I manually uninstall oracle client?
How would you begin to troubleshoot an ORA-3113 error?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?