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

Answer Posted / keshavenas

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
d.Self 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

What is a database schema in oracle?

619


What is a relational database management system?

672


What is define in oracle?

563


What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?

608


What is an oracle transaction?

584






What is format trigger?

1616


How do I recompile a procedure in oracle?

527


What are the major difference between truncate and delete?

515


What are the differences between lov and list item?

559


How to connect asp pages to oracle servers?

571


Does facebook use oracle?

571


How to convert characters to times in oracle?

594


How to declare a local variable?

592


What privilege is needed for a user to create tables in oracle?

548


IS it possible to built the oracle database without setting the kernal parameters?

1759