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
How to use in conditions in oracle?
Explain the difference between a procedure and a function?
How do you store pictures in a database?
Can group functions be mixed with non-group selection fields?
What is the difference between "as" and "is" in an oracle stored procedure?
What is the difference between formal parameters and actual parameters?
What is data block in Oracle?
How to define a record variable to store a table row?
Explain the use of parfile option in exp command.
How to convert numbers to characters in oracle?
Explain coalesce function?
How to bring a tablespace offline?
In which language oracle has been developed?
How to create a new table in your schema?
What is oracle open database communication (odbc)?
