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
What is a connect identifier?
What is Redo Log Buffer in Oracle?
Give the various exception types.
What is bulk collect in oracle?
What are the database administrators utilities available?
How to drop an index in oracle?
Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?
What is integrity and what is constraint??Explain with example
How to omit columns with default values in insert statement in oracle?
What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.
What is dual table oracle?
How to get a list of all user accounts in the database?
Can we write insert statement in function in oracle?
What is a lookup table in oracle?
What is the exact use of Collections?