Interested to Buy Any Domain ? << Click Here >> for more details...
What are joins..how many types of joins are there?
- 29 Answers
- 98090 Views
- Amdocs, CSC, TCS, I also Faced
- E-Mail Answers
Answer Posted / reshma patil
when you want to retrive data from two or more tables then
you require joins.
Types of joins:-
1)Cross join/Cartain join
2)Equi join/inner join
3)Outer join
4)Self join
5)Non-equi join
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Explain the difference between a procedure and a function? What do you understand by those terms?
Explain joins in oracle?
How to update a table row with a record?
What do you mean by merge in oracle and how can we merge two tables?
What is an oracle wallet?
What is the scope of a local variable?
What are set operators?
What is blob datatype?
What is oracle and what are its different editions?
What is a trace file and how is it created in oracle?
Is there a combination of "like" and "in" in sql?
How to increment dates by 1 in oracle?
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?
Explain oracle insert into command?
Explain alias?
