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!

NVL of concatenated columns

user10932986Jul 16 2010 — edited Jul 17 2010
Hi All -

I am trying to achieve the following:

select NVL (column1 || '/' || column2, 'Total') from (select ....)...

The above SQL print out '//' instead of Total....I am trying to concatenate two colmns and want to display 'Total' when their concatenation is null...

What am I doing wrong here?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 14 2010
Added on Jul 16 2010
6 comments
2,320 views