ÓôúÂëÀ´ÊµÏÖ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;