What are joins..how many types of joins are there?
Answer Posted / suresh
Joins are used to fetch a query on more than one table.
You can broadly catagorize joins in to four types.
1. Equi Join
2.Non Equijoin
3.outer joins
4.self joins
Is This Answer Correct ? | 140 Yes | 34 No |
Post New Answer View All Answers
What types of joins are used in writing subqueries?
How to create additional tablespaces for an new database?
How do I use os authentication with weblogic jdriver for oracle and connection pools?
What is parameterized cursor in oracle?
Is oracle a programming language?
What is bulk load in oracle?
Briefly explain what is literal? Give an example where it can be used?
If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...
How to use subqueries with the exists operator in oracle?
What is a procedure in oracle?
What is index-organized table in Oracle?
What is a data dictionary and how can it be created?
What are the ways tablespaces can be managed and how do they differ?
Explain the use of indexes option in exp command.
Explain the use of constraints option in exp command.