public static boolean checkTablesExist(final Connection conn, final String userName, final String tableName)
            throws Exception {
        boolean result = false;
        final String checkTableSql = OracleSqlBuilder.getCheckTable(userName, tableName);
        try (Statement statement = conn.createStatement();
                ResultSet resultSet = statement.executeQuery(checkTableSql)) {
            if (Objects.nonNull(resultSet) && resultSet.next()) {
                int size = resultSet.getInt(1);
                if (size > 0) {
                    result = true;
                }
            }
        }
        LOG.info("check table exist for username={} table={}, result={}", userName, tableName, result);
        return result;
    }
Check tables from the Oracle information_schema.

@param conn JDBC Connection  {@link Connection}
@param userName Oracle database name
@param tableName Oracle table name
@return true if table exist, otherwise false
@throws Exception on check table exist error
inlong-manager/manager-service/src/main/java/org/apache/inlong/manager/service/resource/sink/oracle/OracleJdbcUtils.java