-- 创建自增序列CREATE SEQUENCE seq_interface_infoINCREMENT BY 1 START WITH 1 --从1开始 NOMAXVALUE --不设最大值 NOCYCLE --不循环 NOCACHE; -- 创建表interface_info的触发器CREATE TRIGGER interface_info_trigger BEFORE INSERT -- ON interface_infoFOR EACH ROW BEGIN SELECT seq_interface_info.nextval INTO:new.api_id FROM dual; END; --创建表interface_release的触发器CREATE TRIGGER interface_release_trigger BEFORE INSERT -- ON interface_releaseFOR EACH ROW BEGIN SELECT seq_interface_info.nextval INTO:new.pub_id FROM dual; END;