oracle数据库创建序列，主键自动增1的代码

oracle数据库创建序列，主键自动增1的代码

create sequence MENUWINDOWDEF_SEQ  

minvalue 1

maxvalue 999999999999

start with 1

increment by 1

cache 20;

-----------

create or replace trigger TRG_MENUWINDOWDEF

  before insert on menu_window_def  

  for each row

declare

  -- local variables here

begin

  select MENUWINDOWDEF_SEQ.NEXTVAL INTO :new.KEYID from dual;

end TRG_MENUWINDOWDEF;