Oracle中设置自增id

1.建表：

create table fhj  (

   id              NUMBER               not null,

   filename           VARCHAR(256),

   filetxt           BLOB,

   constraint PK_FHJ primary key (id)

);

2.建自增序列

create sequence fhj_id

minvalue 1

maxvalue 99999999

start with 1

increment by 1

nocache

order;

3.建触发器

create or replace trigger BEF_INS_KHH_COMPANY

before insert on KHH_COMPANY

for each row

declare

nextid number;

begin

IF :new.COMPANY_ID IS NULL or :new.COMPANY_ID=0 THEN

select SEQ_KHH_COMPANY.nextval

into nextid

from sys.dual;

:new.COMPANY_ID:=nextid;

end if;end COMPANY_ID;