What are joins..how many types of joins are there?
- 29 Answers
- 76692 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
What is the data pump import utility?
What is concurrency in oracle?
What do you mean by group by clause?
What is literal?
What is an oracle data file?
What is the difference between translate and replace in oracle?
How to fetch the row which has the max value for a column?
what are the advantages of running a database in archive log mode?
How to use "for" statements in oracle?
How to initialize variables with default values?
How to define default values for formal parameters?
How to define a procedure inside another procedure?
What is a cursor and what are the steps need to be taken?
normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi
Explain drop constraint oracle?
