Oracle数据库中设置表字段为自动序列
标签：
Oracle数据库中设置表字段为自动序列
创建序列
create sequence zonecode_seq start with 1 increment by 1;
--创建触发器
create or replace trigger zonecode_trigger
before insert on org_HospitalZone_dict
for each row
begin
select zonecode_seq.nextval into :new.HOSP_ZONECODE from dual;
end ;
insert into org_HospitalZone_dict(Hosp_Zonename) values(‘1医院‘)
insert into org_HospitalZone_dict(Hosp_Zonename) values(‘2医院‘)
insert into org_HospitalZone_dict(Hosp_Zonename) values(‘3院‘)
insert into org_HospitalZone_dict(Hosp_Zonename) values(‘4院区‘)
select * from org_HospitalZone_dict
delete from org_HospitalZone_dict t where t.hosp_zonecode<5