Interested to Buy Any Domain ? << Click Here >> for more details...
What are joins..how many types of joins are there?
- 29 Answers
- 97210 Views
- Amdocs, CSC, TCS, I also Faced
- E-Mail Answers
Answer Posted / john
Depending on condition existence
----CROSS JOIN (synonyms also CARTESIAN JOIN, CARTESIAN PRODUCT)
----NATURAL JOIN
----# NAMED COLUMNS JOIN - syntactic notation joining source
tables on user defined columns having the same name. This is
less dangerous than Natural join and just short form of
writing Equi joins on some common columns joined together.
Named columns joins always are Equi joins.
----# CONDITIONAL JOIN - fully controllable syntax by user.
This is the most widespread and most useful syntactic
convention. Depending on used predicates in join condition
it may be Equi join as well as Non-equi join.
Depending on row selection
INNER JOIN
OUTER JOIN--- left,right,full
Depending on comparison operator
equi Non-equi
Depending on used tables
SELF JOIN
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
Explain the difference between replace() and translate() functions in oracle?
What is oracle server autotrace in oracle?
how to handle exceptions in post production
How to define an anonymous procedure without variables?
Can sub procedure/function be called recursively?
What is backup in Oracle?
What is a named program unit?
Hi Can any one tell me what are the API's used in requisition import.
How to use subqueries with the exists operator in oracle?
How can we view last record added to a table?
What is the order of defining local variables and sub procedures/functions?
How to assign query results to variables?
What is Data Dictionary Cache in Oracle?
How to define and use table alias names in oracle?
What is different types of joins?
