For unmatched rows returned from an outer join, the column
values in the other table are set to null e.g If A OUTER
JOIN B returns some unmatched rows from A, the
corresponding column values in B will be set to null. What
can be done so that a null value is not displayed for these
columns?
Answer Posted / sankar
You can also use VALUE
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What is the difference between plan and package in db2?
What is dbrm in db2 database?
What is drop table?
what is the responsibility of the construction superintendent
What is cursor in dbms?
What is the difference between bind and rebind in db2?
What is host variable in db2 cobol?
What is db2 purescale?
How can you count the number of rows from a table tab?
What is multi row fetch in db2?
How do I delete a table in database?
How do I change the column size in db2?
What is the role of schema in the db2 database?
What is the picture clause of null indicator variable?
How many types of page locks can be held in db2?