Types of joins ?

Answer Posted / ramesh yadav

IN ORACLE 9i.

Equi - Join = Both are same Names only different
simple join
inner join
Natural join
join

Non - Equi Join

Outer Join
Left outer join
Right outer joi
Full outer join

Self join
Cartesian Product

Is This Answer Correct ?    9 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is sql partition function?

622


Why functions are used in sql?

521


What is t-sql? : Transact sql

546


What is a pdo connection?

521


Is sql considered coding?

575






How many unique keys can a table have?

567


Explain the the delete statements in sql?

583


how can we repair a mysql table? : Sql dba

544


What are all the different normalization?

568


What do you understand by pl/sql packages?

576


What is the example of procedure?

525


Is primary key clustered index?

531


How do I run a sql query?

540


what is a table in a database ? : Sql dba

552


Is sql a microsoft product?

503