批量操作初始化序列初始值代码,PLSQL代码库,德仔网

代码语言

代码分类

【PLSQL】批量操作初始化序列初始值

作者:xinlan1964 / 发布于2014/11/7/ 766


	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;

试试其它关键字

　初始化序列　　初始值　

同语言下

可能有用的

xinlan1964贡献的其它代码(1)

.批量操作初始化序列初始值