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;