What are joins..how many types of joins are there?
- 29 Answers
- 76766 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 use of grant option in exp command.
How to create a new table in oracle?
What is backup in Oracle?
How to add a new column to an existing table with a default value?
How to define a variable to match a table column data type?
What is connection pool in oracle?
what is Single Byte Overhead...?
What are transaction isolation levels supported by oracle?
Explain what are synonyms used for?
What are the advantages of oracle 12c?
Explain rename?
What is meant by recursive hints in oracle?
how can we store any pdf file in oracle
Explain an extent?
What is difference between cartesian join and cross join?
