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!

I want to set to space any null column in my resultset

474128Aug 12 2011 — edited Aug 23 2011
I have a result set that generates rowsets that may have null column entries. The resultset is generated using the sum function.

ex:

ROUND(SUM(mod((column1 - column4)*24, 24)), 2) how_high

is there a to conditional this with something like

ROUND(SUM(mod((column1 - column4)*24, 24)), 2) (*if null then make empty string*)how_high


thanks for any help
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 20 2011
Added on Aug 12 2011
20 comments
2,355 views