作者：忘爱LIAN | 来源：互联网 | 2014-07-08 01:11
Oracle重置sequence语句1Sql代码www.2cto.comDECLAREnNUMBER(10);tsqlVARCHAR2(100);p_seqNamevarchar2(20);BEGINp_seqName:'SEQ_RUN_ID';...
Sql代码 www.2cto.com
DECLARE
n NUMBER(10 );
tsql VARCHAR2(100 );
p_seqName varchar2(20 );
BEGIN
p_seqName := &＃39;SEQ_RUN_ID&＃39;;
EXECUTE IMMEDIATE &＃39;SELECT &＃39; || p_seqName || &＃39;.NEXTVAL FROM dual &＃39; INTO n;
n := - (n - 1);
tsql := &＃39;alter sequence &＃39;|| p_seqName ||&＃39; increment by &＃39; || n;
EXECUTE IMMEDIATE tsql;
EXECUTE IMMEDIATE &＃39;SELECT &＃39; || p_seqName || &＃39;.NEXTVAL FROM dual &＃39; INTO n;
tsql := &＃39;alter sequence &＃39;|| p_seqName ||&＃39; increment by 1&＃39; ;
EXECUTE IMMEDIATE tsql;
EXCEPTION
WHEN OTHERS THEN
dbms_output.put_line( SQLERRM);
END;
京公网安备 11010802041100号 | 京ICP备19059560号-4 | PHP1.CN 第一PHP社区 版权所有 