oracle简单触发器实例讲解

oracle简单触发器实例讲解

create   or   replace   trigger   trg_envparking 
before   insert   on   app_envparking 
for   each   row 
begin 
select   seq_envparking.nextval   into   :new.incid   from   dual; 
select   sysdate   into   :new.constdate   from   dual;
select   sysdate   into   :new.updatedate   from   dual;
end;