Interested to Buy Any Domain ? << Click Here >> for more details...
What are joins..how many types of joins are there?
- 29 Answers
- 97180 Views
- Amdocs, CSC, TCS, I also Faced
- E-Mail Answers
Answer Posted / arpit gautam
Joins condition could be either of the one.
1.SQL SERVER
2.ORACLE SERVER
1.SQL SERVER
SQL SERVER having five joins.
a)CROSS JOIN
b)NATURAL JOIN
c)USING CLAUSE
d)OUTER JOIN
e)ARBITRARY JOIN
2.ORACLE SERVER
a)EQUI JOIN
b)NON EQUI JOIN
c)OUTER JOIN
d)SELF JOIN
| Is This Answer Correct ? | 11 Yes | 1 No |
Post New Answer View All Answers
What are a cluster and non-cluster index?
How to end the current transaction in oracle?
Difference between inner join vs where ?
Why is oracle so popular?
What is an oracle and why it is used?
Explain database link?
How to use fetch statement in a loop?
Explain what are the characteristics of data files?
How to rename a tablespace in oracle?
How many file formats are supported to export data?
What is the difference between Delete, Truncate and Drop in Oracle?
Can you tell me how to add new column in existing views?how?How is possible?
What is the use of aggregate functions in oracle?
Differentiate between function and procedure in oracle.
How do I recompile a procedure in oracle?
