for cust_id in (select cust_code from ec_CLONE_cgt_co_detail where cgt_code='6901028225137')
loop
update ec_CLONE_cgt_co_detail set ord_qty=round(ord_qty*0.93,0)
where cgt_code='6901028225137' and co_num in (select co_num from ec_CLONE_cgt_co where org_code ='11340101'
and order_date =(select distinct replace (varchar(current date) ,'-','') from ec_CLONE_cgt_co))
and cust_code=cust_id.cust_code;
end loop;
commit;
END IF;
END;
毕业设计就这么偷懒,以后走上社会会有苦头吃的
不知道。