How Oracle triggers and tasks are created

1. Create a Trigger

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. Creating a Process

Create or replace procedure Procedure_name_xxx
As
[Var_name_zzz TYPE_NAME_TTT;]
Begin
......;
End

3. Create a task schedule

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

How Oracle triggers and tasks are created