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 / keshireddy
yep. With COALESCE we can
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How and when does the db2 enforces the unique key?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
Can one database have multiple instances?
What are the full forms of spufi and dclgen and why are they used?
Define declaration generator (dclgen).
How do I optimize a query in db2?
What is dbrm library?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
What is the physical storage length of timestamp data type?
How is the value function used?
What is with ur in db2?
Name the lockable units in DB2?
What is a page in db2?
can we view the access paths created by dbrm ? how ? thx
Explain the function of data manager.