various types of joins

Answer Posted / kumar

Types of joins are :

Equi-Join
Non-Equi-Join
Right Outer Join
Left Outer Join
Full Outer Join
Self Join

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to bring a tablespace online?

616


How to start your 10g xe server from command line?

652


What is java oracle used for?

630


How to retrieve values from data fields in record variables?

660


What is bulk load in oracle?

689






 How to use an oracle sequence generator in a mapping?

678


What does sharding mean?

636


How to drop an existing table in oracle?

681


Explain what are the different type of segments?

661


How to drop an index in oracle?

708


What is integrity and what is constraint??Explain with example

1808


What is pragma autonomous transaction in oracle?

638


What is data type in oracle?

652


What is an oracle recycle bin?

638


How to manage transaction isolation level?

650