How do I narrow my search results?
After you submit your search query:
- On the Refine Search results page, select one or more categories of products or services from the left sidebar.
- Then for a category with search results, click Select to choose your product and release filters, and then click OK.
For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"
How do I find the documentation for my product or service?
From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:
- Click the Find a product tab and search for your product or service.
- Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
- Apple Safari: Version 6
- Google Chrome: Version 29 and later
- Mozilla Firefox: Version 24 and later
- Microsoft Internet Explorer: Version 9 and later
ROLLUP Syntax → ROLLUP appears in the GROUP BY clause in a SELECT statement. Its form is: SELECT … GROUP BY ROLLUP … (grouping_column_reference_list) Example 20-2 ROLLUP This example uses the data in the sh sample … schema data, the same data as was used in Figure 20-1. The ROLLUP is across three dimensions. SELECT … ROLLUP(channels.channel_desc,
Aggregate Rollup → If the grouping of data requested by a query is at a coarser level than the grouping of data stored in a materialized view, the optimizer can still use the materialized view to rewrite the query. For example, the materialized view sum_sales_pscat_week_mv groups by prod_subcategory and week_ending_day. This query groups by prod_subcategory, a coarser grouping granularity: ALTER TABLE times MODIFY CONSTRAINT
Partial Rollup → You can also roll up so that only some of the sub-totals will be included. This partial rollup uses … the following syntax: GROUP BY expr1, ROLLUP(expr2, expr3); In this case, the GROUP BY clause … , expr2 ), and ( expr1 ). Example 20-3 Partial ROLLUP SELECT channel_desc, calendar_month_desc … countries.country_iso_code IN ('GB',
Rollup Using a Dimension → When reporting is required at different levels in a hierarchy, materialized views do not have to be created at each level in the hierarchy provided dimensions have been defined. This is because query rewrite can use the relationship information in the dimension to roll up the data in the materialized view to the required level in the hierarchy. In the following example, a query requests data grouped
When to Use ROLLUP → Use the ROLLUP extension in tasks involving subtotals. It is very helpful for subtotaling along a … hierarchical dimension such as time or geography. For instance, a query could specify a ROLLUP(y, m … , day) or ROLLUP(country, state, city). For data warehouse administrators using summary tables, ROLLUP
ROLLUP Extension to GROUP BY → ROLLUP enables a SELECT statement to calculate multiple levels of subtotals across a specified … group of dimensions. It also calculates a grand total. ROLLUP is a simple extension to the GROUP BY … clause, so its syntax is extremely easy to use. The ROLLUP extension is highly efficient, adding minimal … overhead to a query. The
Column Capacity in ROLLUP and CUBE → CUBE, ROLLUP, and GROUPING SETS do not restrict the GROUP BY clause column capacity. The GROUP BY
Hierarchy Handling in ROLLUP and CUBE → The ROLLUP and CUBE extensions work independently of any hierarchy metadata in your system. Their … . This approach enables CUBE and ROLLUP to be used whether or not hierarchy metadata is available … . The simplest way to handle levels in hierarchical dimensions is by using the ROLLUP extension and … this with months rolled up
Using Other Aggregate Functions with ROLLUP and CUBE → The examples in this chapter show ROLLUP and CUBE used with the SUM function. While this is the
Considerations when Using Aggregation → This section discusses the following topics. Hierarchy Handling in ROLLUP and CUBE Column Capacity … in ROLLUP and CUBE HAVING Clause Used with GROUP BY Extensions ORDER BY Clause Used with GROUP BY … Extensions Using Other Aggregate Functions with ROLLUP and CUBE
GROUPING → rows from regular grouped rows. GROUP BY extensions such as ROLLUP and CUBE produce superaggregate … Sal\" FROM employees e, departments d WHERE d.department_id = e.department_id GROUP BY ROLLUP
How to Add Totals to Reports Using the ROLLUP Function → The ROLLUP function enables a SELECT stateme nt to calculate multiple levels of subtotals across a … specified group of dimensions, as well as a grand total. The ROLLUP function is a simple extension … to the GROUP BY clause, so its syntax is extremely easy to use. The ROLLUP function is highly … efficient, adding minimal overhead
USER_ADVISOR_SQLA_REC_SUM → displays recommendation rollup information for the workload objects owned by the current user. Its
Query Rewrite Types Dimensions Primary Key/Foreign Key/Not Null Constraints → Not Required Not Required Aggregate Rollup Not Required Not Required Rollup Using a Dimension
GROUP_ID → ') GROUP BY co.country_region, ROLLUP (co.country_region, co.country_subregion) ORDER BY
Overview of SQL for Aggregation in Data Warehouses → warehouse, Oracle Database provides the following functionality: CUBE and ROLLUP extensions to the … GROUP BY clause Three GROUPING functions GROUPING SETS expression Pivoting operations The CUBE, ROLLUP … , and GROUPING SETS extensions to SQL make querying and reporting easier and faster. CUBE, ROLLUP … grouped rows. ROLLUP
Specifying Hierarchical Cubes in SQL → concatenated rollup (rolling up along the hierarchy of each dimension and then concatenate them across … -16 Concatenated ROLLUP The following shows the GROUP BY clause needed to create a hierarchical cube … concatenated rollup: GROUP BY ROLLUP(year, quarter, month), ROLLUP(Division, brand, item) This
STATS_T_TEST_INDEP and STATS_T_TEST_INDEPU → ) two_sided_p_value FROM sh.customers c, sh.sales s WHERE c.cust_id = s.cust_id GROUP BY ROLLUP … GROUP BY ROLLUP(cust_income_level) ORDER BY income_level, sold_to_men, sold_to_women, t_observed
GROUPING_ID → statement that contains a GROUP BY extension, such as ROLLUP or CUBE, and a GROUPING function. In