没有oracle账号密码oracle简单触发器实例讲解

oracle简单触发器实例讲解

create   or   replace   trigger   trg_envparking before   insert   on   app_envparking for   each   row begin select   seq_enoracle账号vparking.nextval   into   :new.incid   from   dual; select   sysdate   into   :new.CONSTDATE   from   dual;select   sysdate   into   :new.UPDATEDATE   from   dual;end; 

发表在 oracle metalink账号 | 标签为 | 留下评论