oralce plsql工作中的吸取

v_prior_wip   extend_wip%rowtype;

 

select *  into v_prior_wip

    from extend_wip ew

 when ew.sn=p_serial_num

  and ew.active=1;

 

 update routing_wip rw

     set rw.current_level =v_prior_wip.current_levle,

         rw.material_number    = v_prior_wip.material_number,
               rw.material_rstate    = v_prior_wip.material_rstate,
               rw.line_id            = v_prior_wip.line_id,
               rw.station_group      = v_prior_wip.station_group,
               rw.fail_n             = v_prior_wip.fail_n,
               rw.fail_times         = v_prior_wip.fail_times,
               rw.last_modified_time = sysdate
         where rw.sn = p_serial_num;

====================================

 

check_rework_unit_for_krh:

select count(*)

into o_allow

from dual

where v_imei_prefix=(case v_current_pn when '1214-0898' then '35726202'

                                    when '1203-5374' then '35507602'

                                    when '1203-6762' then '35698302'

                                     else v_imei_prefix end);