oracle数据库表实现自增主键的方法实例

 CREATE TABLE "APP_COMM_T"
   (    
    "ID" NUMBER,
    "BASE_KEY" VARCHAR2(50 BYTE),
    "BASE_NAME" VARCHAR2(100 BYTE),
    "BASE_DESC" VARCHAR2(50 BYTE),
    "BASE_TYPE" VARCHAR2(10 BYTE),
    "BASE_SON" VARCHAR2(1 BYTE),
     CONSTRaiNT "APP_COMM_T_PK" PRIMARY KEY ("ID")
   )

create sequence SEQ_APP_COMM_T
 minvalue 1 
 maxvalue 999999   
 increment by 1    
 start with 1;

 create trigger TRIG_APP_COMM_T      
before insert on APP_COMM_T
for each row   
begin       
select SEQ_APP_COMM_T.nextval into :new.id from dual;  
end; 

INSERT INTO APP_COMM_T (BASE_KEY,BASE_NAME,BASE_DESC,BASE_TYPE,BASE_SON)
VALUES('B', 'ADMIN','賬號類型','AccountType','N');