Explain an outer join?
Answer / 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 |
Which is faster delete or truncate?
How do you stop a db2 database in linux?
What is iseries database?
What do you do to keep the cursor from closing after a commit?
what is check point and restart Logic ? why do we go for that ??
In db2, how do you insert multiple rows in 1 query using a.) Cursors, b.) Normal query?? Give syntax for both.
How does a cursor work?
I use CS and update a page. Will the lock be released after I am done with that page?
What is the purpose of the WHENEVER statement?
What is the specific need of Plan and..where are the tables in DB2 are physically saved
what is the role of the cursor in db2?
What is an inner join, and an outer join ?