What are joins..how many types of joins are there?
- 29 Answers
- 76517 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
Can we protect our pl/sql source code?
What are the ansi data types supported in oracle?
What are the limitations of check constraint?
How to retrieve the count of updated rows?
Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com
Can we save images in a database and if yes, how?
What is the database name in oracle?
What do you understand by a database object?
How to create a table interactively?
How to see the table columns used in an index?
In the oracle version 9.3.0.5.0, what does each number shows?
How will you write a query to get a 5th rank student from a table student_report?
What is user managed backup in Oracle?
how the indexes are stored in the Oracle Database?
Explain oracle’s system global area (sga).
