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.创建任务调度
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;