various types of joins

Answer Posted / anjum

There are four types of joins

Inner join (Equi join,Non Equi join)
Outer join (Left outer, Right outer,Full outer)
Self join
Cartesian join

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.

2881


How to view the data files in the current database?

586


How to test null values?

668


What is partitioned table in Oracle?

624


What is a procedure in oracle?

616






can anyody please send me the dump for Oracle 10g certifications for DBA path?

1681


what is IDE,DMV in sql server?

2236


How to delete a user account in oracle?

549


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

606


What is the sql query to concatenate column values from multiple rows in oracle?

557


What happens to the indexes if a table is recovered?

572


What are the tools for Oracle ?

599


What is a snapshot log?

557


How to experiment a data lock in oracle?

593


What is meant by joins?

618