What are joins..how many types of joins are there?
- 29 Answers
- 76762 Views
- Amdocs, CSC, TCS, I also Faced
- E-Mail Answers
Answer Posted / reshma patil
when you want to retrive data from two or more tables then
you require joins.
Types of joins:-
1)Cross join/Cartain join
2)Equi join/inner join
3)Outer join
4)Self join
5)Non-equi join
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What is null value in oracle?
How to run the anonymous block again?
How do you increase the OS limitation for open files (LINUX and/or Solaris)?
Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun
What is snapshot is too old? Give and example for better understand.
Explain rename?
How to fetch the row which has the max value for a column?
How to do paging with oracle?
What is the difference between Delete, Truncate and Drop in Oracle?
1) Does oracle have any table which contain all the exceptions and it's code internally?
How do I manually create a database in oracle?
What is ceil and floor in oracle?
How to login to the server without an instance?
What is ordinary table in oracle?
candidate key is subset of super key but not vice-verse explain
