oracle 批量操作脚本

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;