Interested to Buy Any Domain ? << Click Here >> for more details...
What are joins..how many types of joins are there?
- 29 Answers
- 97081 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
How to fetch the row which has the max value for a column?
How to turn on or off recycle bin for the instance?
What is difference between cartesian join and cross join?
How to export your connection information to a file?
How to convert raw data type into text in oracle? Explain
Explain oracle’s system global area (sga).
How to divide query output into groups in oracle?
How view is different from a table?
What are the types of partitions in oracle?
Can we insert data in view oracle?
How do I reset a sequence in oracle?
Explain the use of full option in exp command.
What is oracle sid?
Which are the five query types available in oracle?
What are the restrictions on external table columns?
