Interested to Buy Any Domain ? << Click Here >> for more details...
What are joins..how many types of joins are there?
- 29 Answers
- 96955 Views
- Amdocs, CSC, TCS, I also Faced
- E-Mail Answers
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 are the numeric comparison operations?
How to drop a tablespace?
Explain the different normalization forms?
What is a cursor and what are the steps need to be taken?
How to view the data files in the current database?
How to write numeric literals in oracle?
How can we delete duplicate rows in a table?
How to connect to a local oracle 10g xe server?
How to create a table in a specific tablespace?
What are the predefined tablespaces in a database?
What do you mean by merge in oracle and how can we merge two tables?
What is a parameter file in oracle?
22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100
Why does Oracle not permit the use of PCTUSED with indexes?
How to turn on or off recycle bin for the instance?
