1. Equi Join 2. Non-Equi join 3. Outer Join 4. Self Join

various types of joins

Question Posted / shankar

Answer Posted / shankar

1. Equi Join
2. Non-Equi join
3. Outer Join
4. Self Join

Is This Answer Correct ?

2 Yes

2 No

Please Help Members By Posting Answers For Below Questions

How to fetch the row which has the max value for a column?

945

Where is the export dump file located?

1079

What is define in oracle?

998

What is an oracle?

955

What are the arithmetic operations?

1020

Can sub procedure/function be called recursively?

945

What is literal?

953

How to Truncate Table in Oracle

1089

When do I need to use a semicolon vs a slash in oracle sql?

1025

Write a trigger example in oracle?

978

What is a cognitive schema?

905

what is meant by magic query

2133

What are the major difference between truncate and delete?

976

Explain what does a control file contain?

1030

What is oracle instant client?

969