欢迎投稿

今日深度:

oracle简单触发器实例讲解,oracle实例讲解

oracle简单触发器实例讲解,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; 

\

www.htsjk.Com true http://www.htsjk.com/oracle/24187.html NewsArticle oracle简单触发器实例讲解,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; se...
评论暂时关闭