declare
V_NUM number;
----多次删除时,每次都将v_num设置成为0
V_NUM := 0;
----判断表 TABLE_NAME 是否存在,注意,表名必须大写,否则找不到表
select count(0) into V_NUM from user_tables where table_name = 'BPD_BUSINESS_INFO';
----如果存在立即删除
if V_NUM > 0 then
execute immediate 'DROP TABLE BPD_BUSINESS_INFO';
end if;
----多次删除时,每次都将v_num设置成为0
V_NUM := 0;
----判断表 TABLE_NAME 是否存在,注意,表名必须大写,否则找不到表
select count(0) into V_NUM from user_tables where table_name = 'BPD_BUSINESS_PROCESS_LINK';
----如果存在立即删除
if V_NUM > 0 then
execute immediate 'DROP TABLE BPD_BUSINESS_PROCESS_LINK';
end if;
END;