Monday, 9 June 2014

How to get back the sequence in plsql block



begin
EXECUTE IMMEDIATE 'alter sequence ' || p_name || ' increment by ' || (p_val - l_num - 1) || ' minvalue 0'

end;

No comments:

Post a Comment