1) SELF JOIN 2) EQUI JOIN(OR) INNER JOIN 2.1) NON-EQUI JOIN 3)OUTER JO

Types of joins ?

Question Posted / a.jyothsna

Answer Posted / a.jyothsna

1) SELF JOIN
2) EQUI JOIN(OR) INNER JOIN
2.1) NON-EQUI JOIN
3)OUTER JOIN
3.1) LEFT OUTER JOIN
3.2) RIGHT OUTER JOIN
3.3) FULL OUTER JOIN

Is This Answer Correct ?

3 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Mention what is the use of function "module procedure" in pl/sql?

1088

What is the max nvarchar size?

1029

Does sql full backup truncate logs?

1080

Explain raise_application_error.

1145

What is sql profiling in oracle?

1131

How many parts of a pl sql block are optional?

1219

How to combine two stored procedures in sql?

1325

How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?

1206

Is it possible to include an insert statement on the same table to which the trigger is assigned?

1064

What is secondary key?

988

Is delete faster than truncate?

1052

How can you fetch common records from two tables?

1104

What is use of package in pl sql?

1070

How do I save a sql query?

1067

how to select first 5 records from a table? : Sql dba

1028