declare num number; begin select count(1) into num from all_tables where TABLE_NAME = upper(‘EMP‘) and OWNER=‘SCOTT‘; if num=1 then execute immediate ‘drop table EMP‘; end if; end;
Oracle如何判断表存在，若存在则进行删除
原文：https://www.cnblogs.com/biabiabia/p/9813496.html
