Interested to Buy Any Domain ? << Click Here >> for more details...
What are joins..how many types of joins are there?
- 29 Answers
- 95765 Views
- Amdocs, CSC, TCS, I also Faced
- E-Mail Answers
Answer Posted / shree
In SQL Server,Join actually puts data from two or more
tables into a sinle result set.
there are 3 types of joins
1.Inner join
2.Outer join
3.Cross join
In Oracle server
1. Equi Join
2.Non Equijoin
3.outer joins
4.self joins
| Is This Answer Correct ? | 47 Yes | 16 No |
Post New Answer View All Answers
What is rowid and rownum in oracle?
Explain enable novalidate constraint.
What is the difference between post-database commit and post-form commit?
Explain the use of file option in exp command.
What is meant by joins? List out the types of joins.
Explain the use of online redo log files in oracle.
How do we create privileges in oracle?
What is an oracle tablespace?
What is the difference between a user and a schema in oracle?
what is Single Byte Overhead...?
How to connect to a local oracle 10g xe server?
What is the difference between pre-select and pre-query?
How to use values from other tables in update statements using oracle?
What language does oracle use?
Can you tell me how to add new column in existing views?how?How is possible?
