oracle利用触发器和sequence实现主键自增长 建立表 -- create tablecreate table geo_bookmark( f_id number not null, f_name v
oracle利用触发器和sequence实现主键自增长
建立表
-- create table
create table geo_bookmark
(
f_id number not null,
f_name varchar2(100) not null,
f_remark varchar2(200),
f_xmin number not null,
f_ymin number not null,
f_xmax number not null,
f_ymax number not null,
f_level number not null,
f_layerids varchar2(50)
)
tablespace prjzc927
pctfree 10
initrans 1
maxtrans 255;
-- create/recreate primary, unique and foreign key constraints
alter table geo_bookmark
add constraint f_pkid primary key (f_id)
using index
tablespace prjzc927
pctfree 10
initrans 2
maxtrans 255;
建立sequence
-- create sequence
create sequence seq_geo_bookmark
minvalue 1
maxvalue 9999999999999
start with 1
increment by 1
cache 20
order;
建立触发器
create or replace trigger trg_geo_bookmark_id
before insert on geo_bookmark
for each row
begin
select seq_geo_bookmark.nextval into :new.f_id from dual;
end;
，