触发器、序列简单应用

//触发器

CREATE OR REPLACE TRIGGER add_watchnum     --建立新的触发器名字为add_watchnum     
  AFTER INSERT                                                                  --表明该触发器在insert动作后执行
  On EPG_VOD_INFO                                                         --要操作的表名称
  for each row
Begin                                                                                     --主体，将 记录是=:new.act_id的watch_num 加1
  update epg_act_info set watch_num = watch_num+1  where act_id= :new.act_id;
 End;     

//序列

-- Create sequence
create sequence SALON_FORUM_INFO_ID_SEQ     --建立序列SALON_FORUM_INFO_ID_SEQ    
minvalue 1                                                                           --最小值
maxvalue 9999999999999999999999999999           --最大值
start with 829                                                                      --序列初始值829
increment by 1                                                                    --间隔1
cache 20
cycle;