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!

Updated Multiple Rows using Update... Case When

Dj SteeleDec 8 2017 — edited Dec 8 2017

Hello,

I have a Customer Table with 10 Rows of Data and when I ran this Update Case When Statement it updated the 5 Rows as I wanted but set the other 5 to NULL

Why?

UPDATE Customer_3

   SET NOTES =

       CASE Customer_ID

            WHEN 191 THEN 'Dads Business Checking'

            WHEN 10  THEN 'Danyelle''s Business Checking for Hair Salon'

            When 189 THEN 'My Checking Account'

            When 11  THEN 'Jordy''s Savings Account'

            When 12  THEN 'Mothers'' Business Checking'

           

       END;

Thanks.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 5 2018
Added on Dec 8 2017
10 comments
1,504 views