作者：领悟人生的悲欢喜乐_829 | 来源：互联网 | 2014-07-08 01:11
Oracle重置sequence语句2Sql代码www.2cto.comCREATEORREPLACEPROCEDURERESET_SEQUENCE(p_sSeqNameINVARCHAR2)ISnNUMBER(10);tsqlVARCHAR2(100);BEGINEXECUTE...
Sql代码 www.2cto.com
CREATE OR REPLACE PROCEDURE RESET_SEQUENCE(p_sSeqName IN VARCHAR2)
IS
n NUMBER(10 );
tsql VARCHAR2(100 );
BEGIN
EXECUTE IMMEDIATE &＃39;SELECT &＃39; || p_sSeqName || &＃39;.NEXTVAL FROM dual &＃39;
INTO n;
n := - (n - 1);
tsql := &＃39;alter sequence &＃39; || p_sSeqName || &＃39; increment by &＃39; || n;
EXECUTE IMMEDIATE tsql;
EXECUTE IMMEDIATE &＃39;SELECT &＃39; || p_sSeqName || &＃39;.NEXTVAL FROM dual &＃39;
INTO n;
tsql := &＃39;alter sequence &＃39; || p_sSeqName || &＃39; increment by 1&＃39; ;
EXECUTE IMMEDIATE tsql;
EXCEPTION WHEN OTHERS THEN
NULL;
END RESET_SEQUENCE;
京公网安备 11010802041100号 | 京ICP备19059560号-4 | PHP1.CN 第一PHP社区 版权所有 
