Database Software

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!

using NVL to remove outer join Null values

404444Mar 3 2004 — edited Mar 8 2004

We have several mappings where we are using outer joins which insert null values for the fields that don't exist in the outer joined table. Instead of nulls we need these values to be a space (' ').

To accomplish this I tried the NVL function between each field in the join and the target (join->nvl->target). The value of the nulls was not affected though. Is there an easier way to replace these nulls?

Thanks,

Matt

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 5 2004

Added on Mar 3 2004

#data-warehousing, #warehouse-builder

3 comments

1,159 views