DECLARE N_ID NUMBER; BEGIN -- N_ID :=1; SELECT MAX(ID)+1 INTO N_ID FROM LAST_TASK_SCHEMA_CACHE; EXECUTE immediate 'ALTER SEQUENCE "SCHEMA"."TABLENAME_SEQ" RESTART START WITH '||N_ID||''; END;
SEQUENCE重新设置 Oracle
最新推荐文章于 2024-01-05 18:06:52 发布
DECLARE N_ID NUMBER; BEGIN -- N_ID :=1; SELECT MAX(ID)+1 INTO N_ID FROM LAST_TASK_SCHEMA_CACHE; EXECUTE immediate 'ALTER SEQUENCE "SCHEMA"."TABLENAME_SEQ" RESTART START WITH '||N_ID||''; END;