various types of joins

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is transaction control statement and how many types of transaction control statement in Oracle?

562


What do database buffers contain?

559


What privilege is needed for a user to query tables in another schema?

502


How to create a table in a specific tablespace?

536


What is the meaning of recursive hints in oracle?

525






What are internal user account in oracle?

567


What are the differences between primary key and unique key?

507


Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.

1859


What are the uses of synonyms?

598


Please explain oracle left join with an example?

581


How remove data files before opening a database?

554


How do you store pictures in a database?

553


What to do if dba lost the system password?

593


Write a syntax for update query in oracle?

614


Explain implicit cursor.

552