create or replace trigger trig_autoinc02
before insert on PREFERENCES
for each row
begin
if (:new.Id is null) then
select preper_seq.nextval into :new.Id from dual;
end if;
end;
before insert on PREFERENCES
for each row
begin
if (:new.Id is null) then
select preper_seq.nextval into :new.Id from dual;
end if;
end;