SQR (Structured Query Reporter) Question:
Download Job Interview Questions and Answers PDF
Explain the difference in using inner join and outer joins?
Answer:
Inner join : An inner join (sometimes called a "simple join") is a
join of two or more tables that returns only those rows that satisfy the join condition.
Outer Joins : An outer join extends the result of a simple join. An
outer join returns all rows that satisfy the join condition and also returns some or all of those rows from one table for which no rows from the other satisfy the join condition
join of two or more tables that returns only those rows that satisfy the join condition.
Outer Joins : An outer join extends the result of a simple join. An
outer join returns all rows that satisfy the join condition and also returns some or all of those rows from one table for which no rows from the other satisfy the join condition
Download Structured Query Reporter (SQR) Interview Questions And Answers
PDF
| Previous Question | Next Question |
| What is Normalization in oracle? | Suppose We wish to print the EMPLID in the BARCODE Format. What are the commands we have to be used in SQR? |