用代碼來實作oracle自動增加1功能

用代碼來實作oracle自動增加1功能

建立序列:-- Create sequence

create sequence IP_Test_SEQUENCES

minvalue 1

maxvalue 99999999999999999999999999

start with 1

increment by 1

cache 20

order;

建立觸發器：

create or replace trigger IP_Test_Trigger

  before insert on ip_test

  for each row

declare

  -- local variables here

  next_id number;

begin

 select IP_Test_Sequences.nextval into next_id from dual;

 :new.id:=next_id;

 --select IP_Test_Sequences.nextval into :new.id from dual;

end IP_Test_Trigger;