What are joins..how many types of joins are there?

Answer Posted / srikanth keshavena

Basically join's are three type's those are :

1.Cross join
2.Equi join
a.Natural join
b.inner join
c.outer join(Simple join)
i.Left outer join
ii.Right outer join
iii.FUll outer join
3.Non-equi join

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How a tablespace is related to data files?

583


What is Redo Log Buffer in Oracle?

634


What is the difference between view and materialized view in Oracle?

610


Explain the truncate in oracle?

549


Explain database link?

666






Hi friends can u send the oracle 9i full version download link?????????????? please reply ?

1442


How to invoke the data pump import utility?

653


What is max rowid in oracle?

559


How to view all columns in an existing table?

551


What happens if the imported table already exists?

549


How do we get field details of a table?

549


How to export your own schema?

572


What is an oracle and why it is used?

623


What is procedure overloading in oracle?

546


WHAT IS ecc 6.0

1664