orale 已存在的表和 SEQUENCE 查询和删除

 

orale 已存在的表和 SEQUENCE 查询和删除

 

declare 
      num   number; 
begin 
      select count(1) into num   from all_tables where TABLE_NAME = 'TU_DIS_ES_COMMISSION_HIST' ;
      if   num=1   then 
          execute immediate 'drop table TU_DIS_ES_COMMISSION_HIST'; 
      end   if; 
      
      
			select  count(1) into num  from  user_sequences  where  sequence_name= UPPER('seq_dis_es_commission_hist');
      
       if   num=1   then 
          execute immediate 'drop SEQUENCE seq_dis_es_commission_hist'; 
      end   if; 
      
end; 
/