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;
转载于:https://www.cnblogs.com/biabiabia/p/9813496.html
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;
转载于:https://www.cnblogs.com/biabiabia/p/9813496.html