mysql 批量修改 序列_批量操作初始化序列初始值

批量初始化序列初始值 无 DECLARE TYPE tsi IS RECORD( t VARCHAR2(100) , s VARCHAR2(100), i varchar2(100)); tsiTemp tsi; maxId varchar2(20);BEGIN for tsiTemp in ( select 'T_xxxx_CONFIG'as t,'SEQ_xxxxx_ID' as s,'xxxx_ID' as i from dual union se

批量初始化序列初始值

DECLARE

TYPE tsi IS RECORD(

t VARCHAR2(100) ,

s VARCHAR2(100),

i varchar2(100));

tsiTemp tsi;

maxId varchar2(20);

BEGIN

for tsiTemp in (

select 'T_xxxx_CONFIG'as t,'SEQ_xxxxx_ID' as s,'xxxx_ID' as i from dual

union

select 'T_ttttt_INFO'as t,'SEQ_ttttt_ID' as s,'tttt_ID' as i from dual

union

select 'T_ddddd_LOG' as t,'SEQ_dddddd_ID' as s,'dddd_ID' as i from dual

)

loop

execute immediate 'select nvl(max('||tsiTemp.i||'+1),1) from '||tsiTemp.t into maxId;

execute immediate 'drop sequence '||tsiTemp.s;

execute immediate 'create sequence '||tsiTemp.s

|| ' minvalue '||maxId

|| ' maxvalue 999999999999999999999999999 '

|| ' start with '||maxId

|| ' increment by 1'

||' cache 20'

||' order';

end loop;

END;

本文原创发布php中文网，转载请注明出处，感谢您的尊重！