Oracle中Sequence每天从1开始

最新推荐文章于 2025-04-07 16:55:44 发布

hello_smu

最新推荐文章于 2025-04-07 16:55:44 发布

阅读量4.4k

点赞数

分类专栏： Oracle

本文链接：https://blog.youkuaiyun.com/hellosmu/article/details/87929103

版权

Oracle 专栏收录该内容

8 篇文章

订阅专栏

CREATE OR REPLACE Procedure Auto_Reset_Sequence(seqName In Varchar2) Is
	n Number;
Begin

	Begin
		Execute Immediate 'select ' || seqName || '.nextval from dual'
			Into n;
		Execute Immediate 'alter sequence ' || seqName || ' increment by -' || n;
		Execute Immediate 'select ' || seqName || '.nextval from dual'
			Into n;
		Execute Immediate 'alter sequence ' || seqName || ' increment by 1 ';
	End;
End;