CREATE SEQUENCE AutoInc INCREMENT BY 1 START WITH 1
MAXVALUE 99999 CYCLE NOCACHE;
建一个BeforeInsert触发器:
SELECT AutoInc.nextval from dual;
CREATE SEQUENCE AutoInc INCREMENT BY 1 START WITH 1
MAXVALUE 99999 CYCLE NOCACHE;
建一个BeforeInsert触发器:
SELECT AutoInc.nextval from dual;