Generally there are five types of joins in oracle: Self Join Equi J

various types of joins

Question 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

Please Help Members By Posting Answers For Below Questions

What is the disadvantage of User defind function?

2343

How to delete an existing row from a table in oracle?

1130

Explain overloading. Can functions be overloaded?

1049

How can we create the complete backup of data in the oracle.

2201

Which is better Oracle or MS SQL? Why?

5037

Can a parameter be passed to a cursor?

1182

Is truncate autocommit in oracle?

1148

Can you create a synonym without having a table?

1095

What are the various constraints used in oracle?

1097

What is integrity and what is constraint??Explain with example

2344

How to define an explicit cursor in oracle?

1102

How to experiment a data lock in oracle?

1112

How to handle a single quote in oracle sql?

1099

What are the differences between interval year to month and interval day to second?

1067

State some uses of redo log files?

1067