oracle如何对数据库判断表是否存在并删除

如何利用oracle判断当前数据库表是否存在并删除，下面web建站小编给大家简单介绍一下具体实现代码！

DECLARE
  tableExists INTEGER;
BEGIN
  SELECT COUNT(*) INTO tableExists FROM user_tables WHERE table_name = '';
 
  IF tableExists > 0 THEN
    EXECUTE IMMEDIATE 'DROP TABLE ';
  END IF;
   
  DBMS_OUTPUT.PUT_LINE('Table  has been dropped successfully');
EXCEPTION
  WHEN OTHERS THEN
    DBMS_OUTPUT.PUT_LINE('Error: ' || SQLERRM(SQLCODE));
END;