various types of joins

Answer Posted / shankar

1. Equi Join
2. Non-Equi join
3. Outer Join
4. Self Join

Is This Answer Correct ?    2 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain joins in oracle?

557


What is the best way to do multi-row insert in oracle?

559


How to get a create statement for an existing table?

570


What is max rowid in oracle?

551


What happens if the imported table already exists?

544






How to assign values to data fields in record variables?

576


How to assign values to variables?

576


What is a subquery?

609


How to use "in out" parameter properly?

610


What is an Oracle index?

1171


What is oracle in java?

517


What is a data lock in oracle?

605


What is PL/SQL ?

1106


How to define default values for formal parameters?

586


How to compare dates in oracle sql?

649