Joins-------------------- We have Equi join, Non-Equi Join, Outer Join,

various types of joins

Question Posted / arkchowdary

Answer Posted / arkchowdary

Joins-------------------- We have
Equi join,
Non-Equi Join,
Outer Join,
Self Join,
Cartesian Join.

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is a static data dictionary in oracle?

1024

How to get last row id?

938

How to get execution path reports on query statements?

927

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

1077

How to write a query with an inner join in oracle?

973

What is using clause and give example?

997

Why do we use bulk collect in oracle?

1010

What is data block in Oracle?

1049

Explain the use of grant option in imp command.

958

Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.

1289

What is meant by an index?

1058

Is the After report trigger fired if the report execution fails ?

2877

Explain what does a control file contain?

1032

Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?

2300

What is a tns file?

938