various types of joins

Answer Posted / kumar

Types of joins are :

Equi-Join
Non-Equi-Join
Right Outer Join
Left Outer Join
Full Outer Join
Self Join

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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

1438


How to loop through a cursor variable?

565


How to divide query output into groups in oracle?

555


why dont we assign not null constraint as table level constraint.

2249


What happens if the imported table already exists?

544






Name the three major set of files on disk that compose a database in Oracle?

628


In oracle there is column command, how will you explain that?

545


how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?

1821


Can you drop an index associated with a unique or primary key constraint?

579


How translate command is different from replace?

542


What are the varoius components of physical database structure of oracle database?

563


How to select all columns of all rows from a table in oracle?

586


How to get execution statistics reports on query statements?

565


How to create a stored procedure in oracle?

571


What are the execution control statements in oracle?

596