sql

最新推荐文章于 2024-10-06 06:56:01 发布

cczz_11

最新推荐文章于 2024-10-06 06:56:01 发布

阅读量455

点赞数 1

文章标签： sql integer

本文链接：https://blog.csdn.net/cczz_11/article/details/6079230

版权

create or replace procedure p_alter_data_datafile
is
  timesum      integer;
  data_sql     varchar2(200);
begin
  timesum := 10;
  for currenttime in 2 .. timesum+1 loop   
     data_sql := 'alter tablespace snsdata add datafile ' 
              || '''/path/datafile' ||currenttime|| '.dbf''' 
     --       || '''+DG'''
              || ' size 8m';
     
     execute immediate data_sql;
   
     --dbms_output.put_line(data_sql);
  end loop;
exception
  when others then
    rollback;
end p_alter_data_datafile;
/

execute p_alter_data_datafile
/