declare p_sql varchar2(4000);
begin
for r in (select SEQUENCE_OWNER,SEQUENCE_NAME from dba_sequences c where sequence_owner='LOANTEST' and SEQUENCE_NAME like 'SEQ_T_LB%' ) loop
p_sql:='alter sequence '||r.SEQUENCE_NAME|| 'increment by 1000';
execute immediate p_sql;
end loop;
end;
declare p_sql varchar2(4000);
begin
for r in (select a.TABLE_NAME from user_tables a where a.TABLE_NAME like 'T_LA_%') loop
p_sql:='delete from '||r.table_name;
execute immediate p_sql;
end loop;
end;