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

Can we create table inside stored procedure?

707


Explain the uses of a database trigger?

792


What is the maximum number of triggers, you can apply on a single table?

745


explain advantages of myisam over innodb? : Sql dba

818


How can one get sql*loader to commit only at the end of the load file? : aql loader

759


how to convert numeric values to character strings? : Sql dba

790


What is sql engine in oracle?

739


What is on delete set null?

797


what is data integrity? : Sql dba

790


What is data type in database?

742


What is the difference among union, minus and intersect?

746


Explain scalar functions in sql?

784


What are the packages in pl sql?

764


What is data manipulation language?

891


Why do we use sql constraints?

877