EquiJoin Non-equijoin Outer join Self join

various types of joins

Question Posted / anurag

Answer Posted / anurag

EquiJoin
Non-equijoin
Outer join
Self join

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is SQL access advisor in Oracle?

1232

How to start an oracle instance?

1076

What is oracle join syntax?

1064

How to get a list of all background sessions in the database?

1046

What are the predefined tablespaces in a database?

1148

How to grant create session privilege to a user in oracle?

1055

Query to retrieve record for a many to many relationship ?

2581

In the oracle version 9.3.0.5.0, what does each number shows?

1352

What are the benefits of ordbms?

1141

What is max rowid in oracle?

1087

How to display employee records who gets more salary than the average salary in the department?

1128

How do you bind variables in oracle?

1024

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

2176

How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?

1972

How to speed up webrick?

1128