Interested to Buy Any Domain ? << Click Here >> for more details...
What are joins..how many types of joins are there?
- 29 Answers
- 96957 Views
- Amdocs, CSC, TCS, I also Faced
- E-Mail Answers
Answer Posted / khaleek
There are three types of joins Equi Join and Non-Equi Join
and Cross Product.
Further Equi join can be divided into following categories...
1) Outer Join
2) Inner Join
3) Self Join
Again Outer join can be divided into following categories..
1) Right Outer Join
2) Left Outer Join
3) Full Outer Join
You can see the detail at..
http://interview-preparation-for-you.blogspot.com/2010/11/difference-between-inner-joinouter-join.html
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to best split csv strings in oracle 9i?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
How to export several tables together?
What are the different types of record groups in oracle? Explain each of them
Explain table?
What happens if recursive calls get out of control?
How to run create database statement?
How to get execution statistics reports on query statements?
What are the attributes that are found in a cursor?
How to start an oracle instance?
How do I escape a reserved word in oracle?
How to import one table back from a dump file?
What is the data type of dual table?
What is literal?
How to concatenate two text values in oracle?
