Oracle的触发器、任务的创建方式

1.创建触发器

create or replace trigger trigger_name_xxx
after delete or update or insert
on table_name_yyy for each row
[declare var_name_zzz type_name_ttt;]
begin
    if delete then
        .....;
    end if;
    if update then
        .....;
    end if;
    if insert then
        .....;
    end if;
end;

2.创建过程

create or replace procedure procedure_name_xxx
as
[var_name_zzz type_name_ttt;]
begin
       ......;
end;

3.创建任务调度job

declare job_name_xxxx number;   
begin
 　　dbms_job.submit(job_name_xxxx,'proc_name_yyyy;',TRUNC(sysdate+1)+2/24,'TRUNC(sysdate+1)+2/24');
end;  或者

DECLARE jobno numeric;

BEGIN

dbms_job.submit(jobno, '   ', , '   ');

END;

4.修改job

BEGIN

DBMS_JOB.change(61, 'getAndSyncKey;',TRUNC(sysdate+1)+4/24, 'TRUNC(sysdate+1)+4/24');

END;

5.删除job

BEGIN

DBMS_JOB.remove(61);

END;

6.运行job

BEGIN

DBMS_JOB.run(61);

END;

7.设置job下一个日期

BEGIN

DBMS_JOB.next_date(61, );

END;

8.设置job时间间隔

BEGIN

DBMS_JOB.interval(61, '');

END;