Package com.oracle.bmc.opsi.model

Class DataObjectTemplatizedQuery.Builder

    • Constructor Detail

      • Builder

        public Builder()

    • Method Detail

      • selectList

        public DataObjectTemplatizedQuery.Builder selectList​(List<String> selectList)
        List of items to be added into the SELECT clause of the query; items will be added with comma separation.
        Parameters:
        selectList - the value to set
        Returns:
        this builder

      • fromClause

        public DataObjectTemplatizedQuery.Builder fromClause​(String fromClause)
        Unique data object name that will be added into the FROM clause of the query, just like a view name in FROM clause.
        • Use actual name of the data objects (e.g: tables, views) in case of Warehouse (e.g: Awr hub) data objects query. SCHEMA.VIEW name syntax can also be used here. e.g: SYS.DBA_HIST_SNAPSHOT or DBA_HIST_SNAPSHOT - Use name of the data object (e.g: SQL_STATS_DO) in case of OPSI data objects. Identifier of the OPSI data object cannot be used here.
        Parameters:
        fromClause - the value to set
        Returns:
        this builder

      • whereConditionsList

        public DataObjectTemplatizedQuery.Builder whereConditionsList​(List<String> whereConditionsList)
        List of items to be added into the WHERE clause of the query; items will be added with AND separation.

        Item can contain a single condition or multiple conditions. Single condition e.g: “optimizer_mode=‘mode1’” Multiple conditions e.g: (module=‘module1’ OR module=‘module2’)

        Parameters:
        whereConditionsList - the value to set
        Returns:
        this builder

      • groupByList

        public DataObjectTemplatizedQuery.Builder groupByList​(List<String> groupByList)
        List of items to be added into the GROUP BY clause of the query; items will be added with comma separation.
        Parameters:
        groupByList - the value to set
        Returns:
        this builder

      • havingConditionsList

        public DataObjectTemplatizedQuery.Builder havingConditionsList​(List<String> havingConditionsList)
        List of items to be added into the HAVING clause of the query; items will be added with AND separation.
        Parameters:
        havingConditionsList - the value to set
        Returns:
        this builder

      • orderByList

        public DataObjectTemplatizedQuery.Builder orderByList​(List<String> orderByList)
        List of items to be added into the ORDER BY clause of the query; items will be added with comma separation.
        Parameters:
        orderByList - the value to set
        Returns:
        this builder