What are joins..how many types of joins are there?
- 29 Answers
- 76833 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 is the relation of a user account and a schema in oracle?
21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.
can anyody please send me the dump for Oracle 10g certifications for DBA path?
How do I uninstall oracle client from windows?
What is the best way to do multi-row insert in oracle?
What is partitioned table in Oracle?
What is the simplest tool to run commands on oracle servers?
What is SQL access advisor in Oracle?
How to drop a stored procedure in oracle?
Differentiate between pre-select and pre-query?
What is the difference between formal parameters and actual parameters?
In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?
In which language oracle has been developed?
What is a synonym? What are its various types?
What is a cursor variable?
