Wednesday, April 10, 2013

Create Sequence with Trigger [For Oracle]


First create a sequence then the trigger..

create sequence id_seq start with 1 increment by 1 nomaxvalue; 


create trigger seq_trigger
before insert on table_name
for each row
begin
select id_seq.nextval into :new.id from dual;
end;

No comments:

Post a Comment