Answers for "can we update multiple record with where statement in oracle"

sql oracle update multiple rows

UPDATE employee
   SET staff_no = 
           CASE depno
                WHEN 1 THEN 'ab123'
                WHEN 2 THEN 'ab321'
                --...
                ELSE staff_no
           END
 WHERE depno IN ( 1, 2 ) -- list all cases here. use a subquery if you don't want to / cannot enumerate

Posted by: Guest on October-14-2020

Code answers related to "can we update multiple record with where statement in oracle"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "can we update multiple record with where statement in oracle"

Code answers related to "can we update multiple record with where statement in oracle"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "can we update multiple record with where statement in oracle"

Code answers related to "can we update multiple record with where statement in oracle"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us