Oracle 数据库——创建序列和触发器命令

创建序列SQL语句:

CREATE SEQUENCE TABLENAME_SEQMINVALUE 1MAXVALUE 999999999999999999999999999START WITH 1INCREMENT by 1NOCACHE;

创建触发器SQL语句:

CREATE OR REPLACE TRIGGER "TABLENAME_TRI" BEFOREINSERT ON jxy_program.TABLENAME FOR EACH ROW declarenext_checkup_no number;beginselect TABLENAME_SEQ.nextvalinto next_checkup_nofrom dual;:NEW.ID := next_checkup_no;end;

先建序列，再建触发器。这样在保存新记录时，主键ID会自动增加。