在oracle 9i里主键的自动增长

 必须创建序列，因为9I版本里没有自动增长

CREATE SEQUENCE seq_表名_字段名
    INCREMENT BY 1
    START WITH 1
    MINVALUE 1
    NOCACHE

create or replace trigger yao_tri
  before insert on 表名
  for each row
begin
select yao_seq.nextval into :new.id from dual;
end yao_tri;

例如：

SQL> create sequence seq_Addressbook_
  2  increment by 1
  3  start with 1
  4  minvalue 1
  5  nocache;

 

SQL> create or replace trigger gaijing
  2  before insert on Addressbook
  3  for each row
  4  begin
  5  select seq_Addressbook_id.nextval into :new.id from dual;
  6  end gaijing;
  7  /

触发器已创建