What are joins..how many types of joins are there?
- 29 Answers
- 76588 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 are temporal data types in oracle?
what is the scenario where you take the database to NoArchivelog mode?
What is Virtual Private Database in Oracle?
Explain an index segment?
How can I see all tables in oracle?
Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.
How to define a data field as not null?
What are the differences between number and binary_float in oracle?
WHAT IS ecc 6.0
What is a partition in oracle?
Explain the use of file option in exp command.
How to convert times to characters in oracle?
Describe an oracle table?
Can the query output be sorted by multiple columns in oracle?
What is oracle in java?
