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 enter data in a table in design view?

516


How do I remove sql plus from windows 10?

567


what is data integrity? : Sql dba

596


What is restrict in sql?

555


What is the difference between local variables and global variables?

609






What is cold data?

504


What program will open a mdb file?

497


What does plv msg allows you to do?

674


What is range partitioning?

521


Explain architecture of sql server notification services?

622


Is foreign key mandatory?

555


what are all the common sql function? : Sql dba

584


What is the difference between joins?

536


What is the need of merge statement?

553


What is the difference between the implicit and explicit cursors?

525