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;
/