DECLARE
v_SN a.serial_number%type;
v_temp_sn a.serial_number%type;
v_date_time a.IN_STATION_TIME%type;
v_line_name a.line_name%type;
v_machine_code a.machine_code%type;
v_product_no a.product_no%type;
v_feeder_no a.feeder_no%type;
v_key_part_no a.key_part_no%type;
v_pkg_id a.pkg_id%type;
v_date_code a.date_code%type;
v_lot_no a.lot_no%type;
v_mfg_pn a.mfg_pn%type;
v_work_time a.work_time%type;
v_end_time a.end_time%type;
v_count int :=0;
v_message varchar2(1000);
CURSOR PCB_SN IS
SELECT line_name,machine_code,product_no,feeder_no,key_part_no,pkg_id,work_time,end_time
FROM a
WHERE line_name in ('B','A')
and (mfg_pn is null or date_code is null)
ORDER
Oracle PL/SQL 游标批量更新数据
最新推荐文章于 2023-02-01 09:33:10 发布