ORACLE中判断数据库中的表存不存在

    //判断表是否存在
        public static bool IsExist(string tablename, OracleConnection strconn)
        {
            String tableNameStr = "select count(*) from user_tables where table_name ='" + tablename.ToUpper() + "'";

            OracleCommand cmd = new OracleCommand(tableNameStr, strconn);
            int result =Convert.ToInt32(cmd.ExecuteScalar());
            if (result == 0)
            {
                return false;
            }
            else
            {
                return true;
            }
        }

原文地址:https://www.cnblogs.com/yichengbo/p/2133870.html