create or replace procedure
reset_seq(seq_name in varchar2)
is
cur_val number;
begin
execute immediate
'select '||seq_name||'.nextval from dual' into cur_val;
execute immediate
execute immediate
'select '||seq_name||'.nextval from dual' into cur_val;
execute immediate
'alter sequence '||seq_name||' increment by 1 minvalue 0';
end;