1 ---- EG.PERSONS表
2 CREATE TABLE PERSONS(
3 ID NUMBER(14) NOT NULL PRIMARY KEY ,
4 LASTNAME VARCHAR2(200),
5 FIRSTNAME VARCHAR2(200),
6 ADDRESS VARCHAR2(1000),
7 CITY VARCHAR(200)
8 );

1 -- Create sequence    
2 create sequence PRO_SEQ              ----索引名稱
3 minvalue 1                           ----最小值
4 maxvalue 999999                      ---最大值
5 start with 1                         ---起始值
6 increment by 1                       ---自增
7 cache 200;                           ---緩存

1 select pid.nextval into :new.pid from dual;    
2 ---第一個pid就是之前序列的名稱，改成自己的即可。 
3 ---第二個pid就是表里需要自增的字段。

1 create or replace trigger SEQ_ID
2   before insert
3   on PERSONS 
4   for each row
5 declare
6   -- local variables here
7 begin
8   SELECT PRO_SEQ.NEXTVAL INTO:NEW.ID FROM DUAL;
9 end SEQ_ID;

1 INSERT INTO PERSONS(LASTNAME,FIRSTNAME,ADDRESS,CITY)VALUES('ALLEN','WALK','PUMING','SHANGHAI');   ----插入時不指定ID列
2 INSERT INTO PERSONS(LASTNAME,FIRSTNAME,ADDRESS,CITY)VALUES('HARRY','JADE','PUMING','SHANGHAI');
3 SELECT * FROM PERSONS;