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 |
What is a view? Why use it?
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
What is the max length of sqlca?
cursor with hold explain ?
What is the picture clause of the null indicator variable?
What DB2 Catalog column tell you when an index needs table reorganized ?
What is the purpose of the SDSNLOAD dataset in the STEPLIB while running DB2 programs?
What is the advantage in De-normalizing tables in DB2?
What is a lock?
what is diffrence b/w file-aid tool and file-aid utility???
Normalization in DB2 – first normal form, second normal form
Can you search give an array in the WHERE clause of a db2 query?