检验表在数据库中是否已存在

DECLARE
   V_COUNT   NUMBER;
   V_OBJTYPE VARCHAR2(200);
   V_SQL     VARCHAR2(500);
   V_NAME    VARCHAR2(200);

BEGIN
  V_NAME := 'DB_LIST_YYAPLUS';//表名
  SELECT COUNT(*) INTO V_COUNT FROM USER_OBJECTS T WHERE T.OBJECT_NAME = V_NAME;//从系统表中查询是否存在
  IF V_COUNT <> 0 THEN
    SELECT OBJECT_TYPE INTO V_OBJTYPE FROM USER_OBJECTS T WHERE T.OBJECT_NAME = V_NAME;
    V_SQL := 'DROP '||V_OBJTYPE||' '||V_NAME;
    EXECUTE IMMEDIATE V_SQL;
  END IF;
  
  V_SQL := 'CREATE TABLE '||V_NAME||'
            (  
              DB_ID      VARCHAR(100),
              DB_NAME    VARCHAR(250),
              DW_CODE    VARCHAR(250),
              DW_NAME    VARCHAR(250),
              ZT_CODE    VARCHAR(250),
              ZT_NAME    VARCHAR(250),
              BEGIN_YEAR VARCHAR(4),
              END_YEAR   VARCHAR(4),
              VERSION    VARCHAR(200),
              XZQH_CODE  VARCHAR(200),
              XZQH_NAME  VARCHAR(200)
            )';
  EXECUTE IMMEDIATE V_SQL;
  
END;