Interested to Buy Any Domain ? << Click Here >> for more details...
What are joins..how many types of joins are there?
- 29 Answers
- 96971 Views
- Amdocs, CSC, TCS, I also Faced
- E-Mail Answers
Answer Posted / shree
In SQL Server,Join actually puts data from two or more
tables into a sinle result set.
there are 3 types of joins
1.Inner join
2.Outer join
3.Cross join
In Oracle server
1. Equi Join
2.Non Equijoin
3.outer joins
4.self joins
| Is This Answer Correct ? | 47 Yes | 16 No |
Post New Answer View All Answers
What is meant by an index?
What do you know about normalization? Explain in detail?
How to name query output columns in oracle?
Where do you use decode and case statements?
HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.
What is the quickest way to fetch the data from a table?
How to define an explicit cursor in oracle?
Explain do view contain data?
Why we use bulk collect in oracle?
What is SQL Tuning Advisor in Oracle?
Explain the difference between sql and oracle?
How to write a query with a left outer join in oracle?
what is Single Byte Overhead...?
What is difference between cartesian join and cross join?
Explain oracle instance.
