1.创建表t1 :create table t1 (id number,name nvarchar(8));
2.创建Oracle序列 :CREATE SEQUENCE t1_id INCREMENT BY 1 START WITH 1 MAXVALUE
3.创建Oracle触发器 : CREATE TRIGGER tig_insert_t1 BEFORE INSERT ON "YINZQ"."T1" begin if (:new.id is null) then select t1_id.nextval into :new.id from dual; //其中的:new.id 指的是t1表中新行的列 end if; end;
举例说明:让Oracle实现自增字段 步骤:先建序列,然后建立一个Oracle触发器实现! cata0是表名,cata0_id是需要自增的字段! CREATE SEQUENCE SEQ_cata0 INCREMENT BY 1 START WITH 1 MAXVALUE 9999999 CREATE TRIGGER TRG_cata0 BEFORE INSERT ON cata0 FOR EACH ROW begin INTO :NEW.cata0_ID from DUAL; End TRG_cata0; /****@PARAM STNAME 不要创建序列的表,多个表则以“,”隔开**/ CREATE OR REPLACE PROCEDURE PROC_CREATE_SEQ_TRIG(STNAME IN VARCHAR2) AS STRSQL VARCHAR2(4000); TABLENAME VARCHAR2(50); PID VARC ......