CREATE TABLE testTable1 ( ID INT NOT NULL, NAME VARCHAR2(4000) NOT NULL, PRIMARY KEY(ID) ) TABLESPACE MYDB;--創(chuàng)建自增ID，名稱為：表名_字段名_SEQ CREATE SEQUENCE testTable1_ID_SEQ MINVALUE 1 NOMAXVALUE INCREMENT BY 1 START WITH 1 NOCACHE;-- 為Insert操作創(chuàng)建觸發(fā)器，無需在SQL語句里寫NEXTVAL，名稱為表名_INS_TRG CREATE OR REPLACE TRIGGER testTable1_INS_TRG BEFORE INSERT ON testTable1 FOR EACH ROW WHEN(NEW.ID IS NULL) BEGIN SELECT testTable1_ID_SEQ.NEXTVAL INTO :NEW.ID FROM DUAL; END;--創(chuàng)建自增ID，名稱為：表名_字段名_SEQ CREATE SEQUENCE lz_Cbenefititem_ID_SEQ MINVALUE 1 NOMAXVALUE INCREMENT BY 1 START WITH 1 NOCACHE; -- 為Insert操作創(chuàng)建觸發(fā)器，無需在SQL語句里寫NEXTVAL，名稱為表名_INS_TRG CREATE OR REPLACE TRIGGER lz_Cbenefititem_pro_INS_TRG BEFORE INSERT ON lz_claimbased_benefititem_pro FOR EACH ROW WHEN(NEW.benefititemno IS NULL) BEGIN SELECT lz_Cbenefititem_ID_SEQ.NEXTVAL INTO :NEW.benefititemno FROM DUAL; END;--創(chuàng)建自增ID，名稱為：表名_字段名_SEQ CREATE SEQUENCE lz_Cclassify_ID_SEQ MINVALUE 1 NOMAXVALUE INCREMENT BY 1 START WITH 1 NOCACHE; -- 為Insert操作創(chuàng)建觸發(fā)器，無需在SQL語句里寫NEXTVAL，名稱為表名_INS_TRG CREATE OR REPLACE TRIGGER lz_CClassify_pro_INS_TRG BEFORE INSERT ON lz_claimbased_classify_pro FOR EACH ROW WHEN(NEW.benefitsclassifyno IS NULL) BEGIN SELECT lz_Cclassify_ID_SEQ.NEXTVAL INTO :NEW.benefitsclassifyno FROM DUAL; END;--創(chuàng)建自增ID，名稱為：表名_字段名_SEQ CREATE SEQUENCE lz_Cdeductible_ID_SEQ MINVALUE 1 NOMAXVALUE INCREMENT BY 1 START WITH 1 NOCACHE; -- 為Insert操作創(chuàng)建觸發(fā)器，無需在SQL語句里寫NEXTVAL，名稱為表名_INS_TRG CREATE OR REPLACE TRIGGER lz_CDeductible_pro_INS_TRG BEFORE INSERT ON lz_claimbased_deductible_pro FOR EACH ROW WHEN(NEW.deductibleno IS NULL) BEGIN SELECT lz_Cdeductible_ID_SEQ.NEXTVAL INTO :NEW.deductibleno FROM DUAL; END;--創(chuàng)建自增ID，名稱為：表名_字段名_SEQ CREATE SEQUENCE lz_Cmaximum_ID_SEQ MINVALUE 1 NOMAXVALUE INCREMENT BY 1 START WITH 1 NOCACHE; -- 為Insert操作創(chuàng)建觸發(fā)器，無需在SQL語句里寫NEXTVAL，名稱為表名_INS_TRG CREATE OR REPLACE TRIGGER lz_Cmaximum_pro_INS_TRG BEFORE INSERT ON lz_claimbased_maximum_pro FOR EACH ROW WHEN(NEW.outofpocketmaximumno IS NULL) BEGIN SELECT lz_Cmaximum_ID_SEQ.NEXTVAL INTO :NEW.outofpocketmaximumno FROM DUAL; END;--創(chuàng)建自增ID，名稱為：表名_字段名_SEQ CREATE SEQUENCE lz_Cbenefits_ID_SEQ MINVALUE 1 NOMAXVALUE INCREMENT BY 1 START WITH 1 NOCACHE; -- 為Insert操作創(chuàng)建觸發(fā)器，無需在SQL語句里寫NEXTVAL，名稱為表名_INS_TRG CREATE OR REPLACE TRIGGER lz_Cbenefits_pro_INS_TRG BEFORE INSERT ON lz_claimbased_benefits_pro FOR EACH ROW WHEN(NEW.benefitsno IS NULL) BEGIN SELECT lz_Cbenefits_ID_SEQ.NEXTVAL INTO :NEW.benefitsno FROM DUAL; END;

?

轉(zhuǎn)載于:https://www.cnblogs.com/Luouy/p/6089652.html

創(chuàng)作挑戰(zhàn)賽新人創(chuàng)作獎勵來咯，堅持創(chuàng)作打卡瓜分現(xiàn)金大獎

總結(jié)

以上是生活随笔為你收集整理的oracle 实现ID自增的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯，歡迎將生活随笔推薦給好友。