What are joins..how many types of joins are there?
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
Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?
How to load excel data sheet to oracle database
How do I connect to oracle database?
Explain what are the different type of segments?
What is an oracle function?
what is difference between sql plus and sql*plus? (not sql and sql plus).
List out the difference between commit, rollback, and savepoint?
How to add a new column to an existing table in oracle?
How to get execution statistics reports on query statements?
What is bind variable in oracle 11g?
6. Display the client name and order date for all orders using the traditional method.
What is the scope of a local variable?
What are the roles of dba?
What are nested tables?
What would you do with an in-doubt distributed transaction?