oracle创建自增长列

oracle创建自增长列

创建序列 
CREATE SEQUENCE SEQ_MT_VIDEO  
MINVALUE 1 
MAXVALUE 999999999999999999 
START WITH 1 
INCREMENT BY 1 
CACHE 20 
NOORDER  
NOCYCLE ;


----创建触发器
create or replace trigger tr_meeting_video 
before insert on T_MEETING_VIDEO_BVM 
for each row
when(new.id is null) 
begin
select SEQ_MT_VIDEO.nextval into :new.id from dual;
end;