oracle sequenece trigger

Oracle trigger for pk based on sequence cheatsheet:

create or replace trigger trg_autonumber
before insert on tbl_autonumber
for each row
begin
  if :new.id is null then
    select seq_autonumber.nextval into :new.id from dual;
  end if;
end;
/

More info: http://www.adp-gmbh.ch/ora/misc/autonumber.html.

$Id: oracle-sequence-trigger.html,v 1.3 2009/02/02 14:26:01 maciej Exp $