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 oracle used for?
How to create a table index?
How to create a table in a specific tablespace?
How to specify default values in insert statement using oracle?
What are joins, explain all types of joins?
What is oracle database client?
What query tells you how much space a tablespace named test is taking up, and how much space is remaining?
Explain database link?
How to list all indexes in your schema?
What is oracle rowcount?
candidate key is subset of super key but not vice-verse explain
What is a directory object?
How to use "while" statements in oracle?
How to shutdown your 10g xe server from command line?
What is a nvl function? How can it be used?