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 are group functions in oracle?
How to delete a column in an existing table in oracle?
Is oracle a programming language?
What is a cognitive schema?
Give the constructs of a package, function or a procedure.
What is transport network substrate (tns) in oracle?
What is a sub query? What are its various types?
What is oracle rowcount?
Explain what are the type of synonyms?
How does oracle handle read consistency?
Can we commit inside a function in oracle?
WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?
Explain joins in oracle?
What is backup in Oracle?
What happens if you use a wrong connect identifier?
