oracle 存储过程实例

最新推荐文章于 2018-10-17 14:47:13 发布

weixin_34320159

最新推荐文章于 2018-10-17 14:47:13 发布

阅读量73

点赞数

原文链接：http://www.cnblogs.com/wudi521/p/6291776.html

版权

create or replace
procedure test_paramout_01(staff_id_str in VARCHAR2,ticket_seq_str in number,schedule_date_str in VARCHAR2)
 is
   begin
   update twf_tech_schedule tts set  ticket_seq = (ticket_seq+1)  where tts.staff_id=staff_id_str  and tts.ticket_seq>=ticket_seq_str and tts.schedule_date>=to_date(schedule_date_str,'yyyy-mm-dd');
 END;

create or replace
procedure test_paramout_01(staff_id_str in VARCHAR2,ticket_seq_str in number,schedule_date_str in VARCHAR2)
 is
   begin
     for emm in(select tts.work_item,tts.ticket_seq from twf_tech_schedule tts where tts.staff_id=staff_id_str  and tts.ticket_seq>=ticket_seq_str and tts.schedule_date>=to_date(schedule_date_str,'yyyy-mm-dd')) loop              
      update twf_tech_schedule set  ticket_seq = (ticket_seq+1) where work_item = emm.work_item;
     dbms_output.put_line(emm.ticket_seq);
    end loop;
 END;

转载于:https://www.cnblogs.com/wudi521/p/6291776.html