刚接触oracle新手问题关于触发器

create table Dict_System"

(

   ID                   NUMBER(4),

   PID                  NUMBER(4),

   NodeName          VARCHAR(20),

   PathName         VARCHAR(200),

   OrderIndex         NUMBER(2),

   IsEnable           NUMBER(1)

)

create sequence SEQ_DICT

minvalue 1

maxvalue 9999

start with 1

increment by 1

cache 20

order;

create or replace trigger Trig_Dict

  before insert on dict_system  

  for each row

begin

  select seq_dict.nextval into: new.id from dual;

end Trig_Dict;

insert into dict_system (pid,nodename,pathname,orderindex,isenable) values ('0','系统设置','system','1','1');