Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to do Handle Null value with Different Columns

User430585 -OracleApr 6 2012 — edited Apr 6 2012
Hi Gurus,

I have Requirement in Oracle Reports :

Eg:- I have a table Temp with three columns A, B and C

My Requirement is IF columns A, B and C are null then in the Report Output it should return as C as 0, B as None and A as None.
if any values are there in A, B or C columns then Report output should return those values.

All your inputs are highly appreciated.

Thanks
This post has been answered by MichaelS on Apr 6 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 4 2012
Added on Apr 6 2012
#database, #oracle, #pl-sql, #plsql, #query, #report, #table, #xml
8 comments
647 views