表名 table_name,主键 ID
CREATE SEQUENCE table_name_ID_SEQ
MINVALUE 1 NOMAXVALUE INCREMENT BY 1 START WITH 1
NOCACHE;
CREATE OR REPLACE TRIGGER table_name_INS_TRG
BEFORE INSERT ON table_name
FOR EACH ROW
BEGIN
SELECT table_name_ID_SEQ .NEXTVAL INTO :NEW.ID FROM DUAL;
END;