批量更新sql

 

 

update nation_scoreinfo ns
  set ns.tt_case=decode(ns.tt_case,'05','06',ns.tt_case)
  , ns.oo_case=decode(ns.oo_case,'05','06',ns.oo_case)
  , ns.gg_case=decode(ns.gg_case,'05','06',ns.gg_case)
  , ns.ee_case=decode(ns.ee_case,'05','06',ns.ee_case)
  , ns.score_status = 4
 where ns.isdel<>1 
        and (
            ns.exam_card_num is not null
        ) 
        and (
            ns.examinee_uuid is not null
        ) 
       and ns.score_status='3' 
        and ns.plan_uuid='cbaa6d10-68a6-4ac2-8932-dd87c00f16fd' 
        and ns.work_name='企业人力资源管理师' 
        and ns.level_name='三级'