DMONIX

index

Trigger CUSTTRIGGER
Trigger Information
Trigger Type BEFORE EACH ROW
Triggering Event INSERT OR UPDATE
Base Object Type TABLE
Table Name CUSTOMER
Trigger Body 
begin
 if :new.id = null then
   select dmonix.idsequence.nextval into :new.id from dual;
 end if;

end;