/*创建自增序列*/
CREATE SEQUENCE CMB_CHINA_CITYS_ID
MINVALUE 1 --最小值
NOMAXVALUE --不设置最大值
START WITH 2000 --从1开始计数
INCREMENT BY 1 --每次加1
NOCYCLE --一直累加,不循环
NOCACHE; --不建缓冲区
/*创建触发器*/
CREATE OR REPLACE TRIGGER AUTOQY
BEFORE INSERT ON PJ_JS_QYJCXX
FOR EACH ROW
DECLARE
BEGIN
SELECT CMB_CHINA_CITYS_ID.NEXTVAL INTO :NEW.QYJCXX_ID FROM DUAL;
END AUTOQY;
PJ_JS_QYJCXX:表名
QYJCXX_ID:表的主键
AUTOQY:触发器名