Answer Posted / vamsikrishnamraju
An outer join operation returns all the rows returned by an
inner join plus all the rows from one table that do not
match any row from the other table. An outer join can be
left, right, or full, depending on whether rows from the
left, right, or both tables are retained
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Comment whether the cursor is closed during commit or not.
What is a buffer in memory?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
How do I add a column to an existing table in db2?
What is a plan and package in db2?
What are the full forms of spufi and dclgen and why are they used?
How would the varchar column remarks defined?
What is sqlca?
Explain packages.
How do I delete a table in database?
What is a storage group (stogroup)?
How is a typical db2 batch pgm executed?
How to find the number of rows in a db2 table?
Define data page.
Is db2 a programming language?