摘要： http://www.cnblogs.com/zjfree/archive/2012/01/10/2318376.html 阅读全文

摘要： create or replace trigger update_sys_ins_tasks before update on sys_inst_tasks for each rowdeclare -- local variables here finished number; nowproc VARCHAR2(4000);begin finished := :new.finished; nowproc := :new.nowproc; if finished = 1 and nowproc <> '完成' then :new.nowproc := '等待打 阅读全文