//触发器
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;