There are Two Types of joins: I. Inner Join II. Outer Join I: Inne

various types of joins

Question Posted / s. senthil kumar

9 Answers
10542 Views
I also Faced
E-Mail Answers

Answer Posted / s. senthil kumar

There are Two Types of joins:

I. Inner Join
II. Outer Join

I: Inner join:a) Equi join, b) Non Equi join c) self join
II: Outer join: a) Left outer join, b) right outer join,
c) Full outer join

Is This Answer Correct ?

6 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the Tune Query

2345

Explain an index?

1182

What is tns name?

1026

What is a nested table?

1111

How to find out what oracle odbc drivers are installed?

1092

How to do paging with oracle?

1049

An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?

2103

What is oracle join syntax?

1061

How to open a cursor variable?

1089

How to connect to oracle using service name instead of sid?

1068

is there a tool to trace queries, like profiler for sql server?

1196

What is bulk copy or bcp in oracle?

1184

How to shutdown your 10g xe server?

1205

How can windows applications connect to oracle servers?

1115

What is the difference between a user and a schema in oracle?

1079