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

if you ctreate table identity

2372

What is MTTR advisor in Oracle?

1090

How to write date and time literals in oracle?

1002

Explain what are the advantages of views?

1069

How to find out what oracle odbc drivers are installed?

1040

What is the scope of a local variable?

1067

State and explain the different types of data models?

942

How to start a specific oracle instance?

1037

What is the implicit cursor in oracle?

1105

What is the maximum number of triggers that can be applied to a single table?

1021

How to insert a new row into a table in oracle?

1162

Why do you use stored procedures and state some of its disadvantages?

1028

Is there an oracle sql query that aggregates multiple rows into one row?

976

Explain the use of inctype option in exp command.

1034

What are the different types of record groups in oracle? Explain each of them

1025