What are inner join and outer join?

Answer Posted / akn

Inner join is the most common type of join. Inner joins
return all rows from multiple tables where the join
condition is met.

Outer join returns all rows from one table and only those
rows from a secondary table where the joined fields are
equal (join condition is met).

Is This Answer Correct ?    17 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is meant by raw datatype?

556


What is a dead lock in oracle?

583


How to drop an existing table in oracle?

585


Explain an exception and its types?

603


Explain the use of rows option in imp command.

600






How to check your oracle database 10g xe installation?

575


How do I uninstall oracle client from windows?

532


Explain implicit cursor.

546


How data locks are respected in oracle?

566


How to create an oracle testing table?

584


What happens if you set the sga too low in oracle?

546


Explain what does a control file contain?

604


What do you mean by merge in oracle?

589


What are the differences between number and binary_float in oracle?

559


What are the arithmetic operations?

574