What are joins..how many types of joins are there?
- 29 Answers
- 76688 Views
- Amdocs, CSC, TCS, I also Faced
- E-Mail Answers
Answer Posted / mouli
Joins allows you to read or report the data from more than 1 table. There are four types of joins are there..
1) equi join or inner join or natural join
2) non equi join
3) outer join
a)left outer join
b)right outer join
c)full outer join
4) self joins
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is blob datatype?
What is meant by a deadlock situation?
How to use "while" statements in oracle?
When do you get a .pll extension in oracle? Explain its importance
Explain alias?
What are operators in oracle?
Differentiate between pre-select and pre-query?
How to return top 5 rows in oracle?
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
How to store only time; not date and time?
What is bulk collect in oracle?
How can I create database in oracle?
How to create a server parameter file?
Is oracle a language?
What privilege is needed for a user to query tables in another schema?
