Interested to Buy Any Domain ? << Click Here >> for more details...
What are joins..how many types of joins are there?
- 29 Answers
- 95796 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 check the oracle tns settings?
How to define a specific record type?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
What is an external table?
What is a named program unit?
How to define a data source name (dsn) in odbc manager?
How to create an oracle testing table?
what are the advantages of running a database in archive log mode?
How many types of cluster table in Oracle?
Is oracle an operator?
Can group functions be mixed with non-group selection fields?
What is the difference between truncate & delete command?
How to load a large xml file?
How to open and close an explicit cursor in oracle?
What is blob data type in oracle?
