--如果表中存在记录，先把原来的数据赋值
UPDATE EQUIPMENT_MANAGEMENT_LIST SET ID=ROWNUM;
--创建序列，设置初始值和每次增长值
CREATE SEQUENCE EQUIPMENT_MANAGEMENT_ID_SEQ MINVALUE 1 NOMAXVALUE INCREMENT BY 1 START WITH 1 NOCACHE;
--创建触发器，请注意这个格式。。。
CREATE OR REPLACE TRIGGER EQUIPMENT_MANAGEMENT_TRG BEFORE INSERT ON EQUIPMENT_MANAGEMENT_LIST FOR EACH ROW WHEN(NEW.ID IS NULL OR NEW.ID = 0)
BEGIN
SELECT EQUIPMENT_MANAGEMENT_ID_SEQ.NEXTVAL INTO :NEW.ID FROM DUAL;
END;