Interested to Buy Any Domain ? << Click Here >> for more details...
What are joins..how many types of joins are there?
- 29 Answers
- 96945 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 select all columns of all rows from a table in oracle?
Explain an index segment?
What do you know about normalization? Explain in detail?
How to rename an index?
Is insert autocommit in oracle?
What do you understand by a database object?
How many data types are supported?
What is the use of file param in imp command?
What is meant by joins?
What is Virtual Private Database in Oracle?
How would you begin to troubleshoot an ORA-3113 error?
Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com
How to rename an index in oracle?
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
What is MTTR advisor in Oracle?
