oracle数据库与其他的数据库不太一样,比如在mysql里自动增长只要设定“auto_increment”即可。可是在oracle里就麻烦了。本文就说说在oracle里建立自动增长的字段。
-- Create tablecreate table USERINFO(ID NUMBER not null,USERNAME VARCHAR2(25) not null,PASSWORD VARCHAR2(50) not null)
-- Create sequencecreate sequence USERINFO_AUTOINCminvalue 1maxvalue 999999999999999999999999999start with 2increment by 1nocache;
create or replace trigger insert_for_autoincbefore insert on userinfofor each rowdeclare-- local variables herebeginselect USERINFO_AUTOINC.nextval into :new.ID from dual;end insert_for_autoinc;
4.SQL测试结果
联系客服