Oracle uses triggers and sequence to achieve auto-Growth of primary keys

Oracle uses triggers and sequence to achieve auto-Growth of primary keys

Create a table

-- 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;

Establish Sequence

-- Create sequence
Create sequence SEQ_GEO_BOOKMARK
Minvalue 1
Max value 9999999999999
Start with 1
Increment by 1
Cache 20
Order;

Create a trigger

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;