批量初始化序列初始值 无 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;
每个人都需要一台速度更快、更稳定的 PC。随着时间的推移，垃圾文件、旧注册表数据和不必要的后台进程会占用资源并降低性能。幸运的是，许多工具可以让 Windows 保持平稳运行。
广告
收藏
收藏
收藏
Copyright 2014-2025 https://www.php.cn/ All Rights Reserved | php.cn | 湘ICP备2023035733号
244
