Skip to Main Content

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!

Merge only when new values are not null

GCJoeBFeb 11 2015 — edited Feb 17 2015

Hello all,

How would I create merge statements that will not update fields where the new values are not null?

I am using a template I created in Excel to generate scripts based on information put into the sheet from other users.  Some times they don't provide values which ends up in the script as a null value or ''.

This method is used to generate 10's of thousands of scripts and if there is a way I can prevent the null values from merging over existing values, that would be superb.

Thank you in advance

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 17 2015
Added on Feb 11 2015
9 comments
5,175 views