oracle 序列初始化的plsql塊指令碼

標籤：

declare
seq_name dba_sequences.SEQUENCE_NAME%TYPE;
cursor mycur is
select * from dba_sequences where sequence_owner=‘NETHRA‘;
query_row dba_sequences%rowtype;
begin
open mycur; --開啟遊標
loop
fetch mycur into query_row; --把遊標所指的紀錄放到變數中
exit when (mycur%notfound); --當遊標沒有指向行時退出迴圈
DBMS_OUTPUT.put_line(‘SEQ有：‘ || query_row.SEQUENCE_NAME || ‘條記錄‘);
--execute immediate ‘drop sequence ‘||query_row.SEQUENCE_NAME;
--execute immediate ‘create sequence ‘||query_row.SEQUENCE_NAME||‘ minvalue 1 maxvalue 999999999999999999999999999 start with 1 increment by 1 nocache‘;
end loop;
close mycur;
end;

oracle 序列初始化的plsql塊指令碼