在開發(fā)過程中，可能會用到oracle sequence語句,本文以oracle sequence語句如何重置進(jìn)行介紹，需要的朋友可以參考下

Oracle重置sequence語句1

Sql代碼

DECLARE

n NUMBER(10 );

tsql VARCHAR2(100 );

p_seqName varchar2(20 );

BEGIN

p_seqName := 'SEQ_RUN_ID';

EXECUTE IMMEDIATE 'SELECT ' || p_seqName || '.NEXTVAL FROM dual ' INTO n;

n := - (n - 1);

tsql := 'alter sequence '|| p_seqName ||' increment by ' || n;

EXECUTE IMMEDIATE tsql;

EXECUTE IMMEDIATE 'SELECT ' || p_seqName || '.NEXTVAL FROM dual ' INTO n;

tsql := 'alter sequence '|| p_seqName ||' increment by 1' ;

EXECUTE IMMEDIATE tsql;

EXCEPTION

WHEN OTHERS THEN

dbms_output.put_line( SQLERRM);

END;

Oracle重置sequence語句2

Sql代碼

CREATE OR REPLACE PROCEDURE RESET_SEQUENCE(p_sSeqName IN VARCHAR2)

IS

n NUMBER(10 );

tsql VARCHAR2(100 );

BEGIN

EXECUTE IMMEDIATE 'SELECT ' || p_sSeqName || '.NEXTVAL FROM dual '

INTO n;

n := - (n - 1);

tsql := 'alter sequence ' || p_sSeqName || ' increment by ' || n;

EXECUTE IMMEDIATE tsql;

EXECUTE IMMEDIATE 'SELECT ' || p_sSeqName || '.NEXTVAL FROM dual '

INTO n;

tsql := 'alter sequence ' || p_sSeqName || ' increment by 1' ;

EXECUTE IMMEDIATE tsql;

EXCEPTION WHEN OTHERS THEN

NULL;

END RESET_SEQUENCE;

總結(jié)

以上是生活随笔為你收集整理的oracle复制sequence,oracle sequence语句重置方介绍的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯，歡迎將生活随笔推薦給好友。