ORACLE 判斷TALBE 存不存在SQL COMMAND

DECLARE tbl_exist PLS_INTEGER;

BEGIN
select count(*) into tbl_exist from user_tables where table_name = 'mytable';
if tbl_exist = 1 then
execute immediate 'drop table mytable';
end if;

END;
參考來源