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 a connect identifier?

525


What is Redo Log Buffer in Oracle?

606


Give the various exception types.

524


What is bulk collect in oracle?

532


What are the database administrators utilities available?

558






How to drop an index in oracle?

578


Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?

1846


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

1675


How to omit columns with default values in insert statement in oracle?

555


What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.

526


What is dual table oracle?

505


How to get a list of all user accounts in the database?

586


Can we write insert statement in function in oracle?

505


What is a lookup table in oracle?

514


What is the exact use of Collections?

1654