miércoles, 20 de junio de 2012

Triggers y Sequence


create sequence seqLiquidacion
start with 1
increment by 1
nomaxvalue;

create trigger liquidacionIncr
before insert on liquidacion
for each row
begin
select seqLiquidacion.nextval into :new.idliquidacion from dual;
end;

No hay comentarios:

Publicar un comentario