Interested to Buy Any Domain ? << Click Here >> for more details...
What are joins..how many types of joins are there?
- 29 Answers
- 96976 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 oracle server autotrace in oracle?
What is the fastest query method to fetch data from the table?
How to assign a table row to a record variable?
What is oracle analytical function?
Is oracle a programming language?
How to return top 5 rows in oracle?
What is a snapshot in oracle database?
What is define in oracle?
Explain how you would restore a database using RMAN to Point in Time?
How many file formats are supported to export data?
Explain a synonym?
What is varray?
Is oracle a language?
How to handle a single quote in oracle sql?
Who developed oracle & when?
