Interested to Buy Any Domain ? << Click Here >> for more details...
What are joins..how many types of joins are there?
- 29 Answers
- 98093 Views
- Amdocs, CSC, TCS, I also Faced
- E-Mail Answers
Answer Posted / prabhat shukla
Basically there are three types of join
1.Inner join
2.Outer join
3.self join
and there are two types of join based on condition.
1.equi-join(if we use equal operator while joining tables)
2.Non-equi-join( if we use other than equal operator while
joining tables.(this on is rarely used.)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is MTTR advisor in Oracle?
Can you tell me how to add new column in existing views?how?How is possible?
What is the Tune Query
How will you identify oracle database software release?
What is oracle rowcount?
How to compare dates in oracle sql?
Is primary key indexed by default in oracle?
What is object data modeling?
How to add a new column to an existing table in oracle?
What is a data dictionary and how can it be created?
Please explain oracle left join with an example?
What is tns name?
How to list all tables in your schema?
What is Library Cache in Oracle?
What is enter substitution variable in oracle?
