oracle主键自增触发器

CREATE OR REPLACE TRIGGER mycollect_trigger BEFOREinsert ON  rescollectorbuy FOR EACH ROWbeginselect SEQ_MYCOLLECT.nextval into:New.id from dual;end;