What are joins..how many types of joins are there?
Answer Posted / pravin
Joins are used to fetch data or information from one or
more tables and there are five types of join.
1. Inner Join
2. Outer Join
3. Self Join
4. Cross Join
5. Exception Join
| Is This Answer Correct ? | 27 Yes | 40 No |
Post New Answer View All Answers
What is the best way to do multi-row insert in oracle?
What happens if you use a wrong connect identifier?
How to rebuild an index in oracle?
How many types of segments in Oracle?
How to start your 10g xe server?
How to get a list of all user accounts in the database?
What is a nested table and how is it different from a normal table?
Explain the use of full option in exp command.
How different is ms access and oracle?
What are a query and state the different types of queries and their uses?
Explain coalesce function?
How many memory layers are in the oracle shared pool?
What is a user account in oracle?
Explain the features of oracle?
How to call a stored function with parameters?