ORACLE_SEQUENCE建立

1.为一张表的主键ID建立一个Sequence

CREATE SEQUENCE "SEQ_TB_ID" MINVALUE 1 MAXVALUE 99999999999999999999 

INCREMENT BY 1 START WITH 1 NOCACHE NOCYCLE NOORDER

2.建立一个Trigger使Sequence与表关联

CREATE OR REPLACE TRIGGER "TRI_TB_ID"

  BEFORE INSERT ON "TEST_BLOB" --表名(ID为主键)

  FOR EACH ROW

BEGIN

  IF INSERTING THEN

    IF :NEW."ID" IS NULL THEN

      SELECT SEQ_TB_ID.Nextval INTO :NEW."ID" FROM DUAL;

    END IF;

  END IF;

END;