批量建立索引

条件跟建表语句一样，需要resource和显示指定create table权限
create or replace procedure create_x_index(s varchar2,i integer,s2 varchar2,s3 varchar2)
is
  cur integer;
begin
  cur:=dbms_sql.open_cursor;
  for lc in 1..i loop
    dbms_sql.parse(cur,s||lc||s2||lc||s3,dbms_sql.native);
  end loop;
  dbms_sql.close_cursor(cur);
exception
  when others then
    dbms_sql.close_cursor(cur);
end create_x_index;