various types of joins

Answer Posted / samir kumar sahoo

Generally there are five types of joins in oracle:

Self Join
Equi Join
Cartesian Join
Outer Join(Left outer join,Right outer join)
Non_Equi JOin

Is This Answer Correct ?    7 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to define an oracle sub procedure?

595


What is connection pooling in oracle?

552


What is backup in Oracle?

569


Calculate difference between 2 date / times in oracle sql?

571


What would you do with an in-doubt distributed transaction?

1468






What is oracle database client?

553


What is a sub query and what are the different types of subqueries?

624


What is data file?

617


How to drop an existing table in oracle?

592


Explain how are indexes update?

621


List out the components of logical database structure of oracle database.

583


How do you store pictures in a database?

560


How can I introduce multiple conditions in like operator?

553


How to change user password in oracle?

605


Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables

1580