Oralce 增加 删除 主键 索引

declare
v_key varchar2(500);
v_sql varchar2(500);
begin
   select max(cu.constraint_name) into v_key
    from user_cons_columns cu, user_constraints au
   where cu.constraint_name = au.constraint_name
   and au.constraint_type = 'P'
   and au.table_name = 'temp_table ';
   
   v_sql:='alter table temp_table drop constraint '||v_key||' cascade'; 
   execute immediate v_sql;
end;
/


--处理表 索引处理  temp_table 
declare
  v_key varchar2(500);
  v_num number;
  v_sql varchar2(500);
begin
  select count (t.index_name) into v_num from user_ind_columns t where t.table_name = 'temp_table ';
  if v_num >0 then
    select distinct (t.index_name) into v_key from user_ind_columns t where t.table_name = 'temp_table ';
       if v_key is not null then
         v_sql := 'drop index ' || v_key || '';
         execute immediate v_sql;
         v_sql :='create un