What are joins..how many types of joins are there?
- 29 Answers
- 76454 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 a user account in oracle?
Explain do view contain data?
What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.
Can objects of the same schema reside in different tablespace?
What do you mean by merge in oracle and how can we merge two tables?
Give the different types of rollback segments.
What is oracle analytical function?
Why should I use oracle database?
What is the recommended interval at which to run statspack snapshots, and why?
Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?
What are a cluster and non-cluster index?
How to load a large xml file?
How to download oracle database 10g xe?
What is a cursor in oracle?
what is the use of triggers in Java program? I mean where do we use triggers in Java programming?
