create or replace trigger DAILYPRODUCTT
before insert on DAILYPRODUCT
for each row
declare
--local variables here
begin
select DAILYPRODUCTS.nextval into :new.id from sys.dual;
before insert on DAILYPRODUCT
for each row
declare
--local variables here
begin
select DAILYPRODUCTS.nextval into :new.id from sys.dual;
end;
-- Create sequence
create sequence DAILYPRODUCTS
minvalue 1
maxvalue 99999999
start with 21
increment by 1
cache 20;