创建表 CREATE TABLE DATAX_DATA_SYNCHRONISM_INFO ( DATAX_ID NUMBER PRIMARY KEY, TABLENAME VARCHAR2(100) , SYNTYPE VARCHAR2(20), T0TALCOUNT NUMBER DEFAULT 0, SUCCOUNT NUMBER DEFAULT 0, ERRCOUNT NUMBER DEFAULT 0, SYNTIME DATE DEFAULT SYSDATE ) 创建序列 CREATE SEQUENCE SEQ_DATAX_DATA_SYNCHRONISM_INFO INCREMENT BY 1 START WITH 1 NOMAXVALUE NOCYCLE NOCACHE 创建触发器 CREATE OR REPLACE TRIGGER TRI_DATAX_DATA_SYNCHRONISM_INFO before insert on DATAX_DATA_SYNCHRONISM_INFO for each row begin select SEQ_DATAX_DATA_SYNCHRONISM_INFO.nextval into :new.datax_id from dual; end;