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 21-2 ROLLUP This example uses the data in the sh sample … schema data, the same data as was used in Figure 21-1. The ROLLUP is across three dimensions. SELECT … ROLLUP(channels.channel_desc,
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 21-3 Partial ROLLUP SELECT channel_desc, calendar_month_desc … countries.country_iso_code IN ('GB',
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
ROLLUP By Time ROLLUP By Product ROLLUP By Geography → specified in the previous SQL will take the ROLLUP aggregations listed in the table and perform a cross … hierarchical cube of the data. There are major advantages in using three ROLLUP expressions to replace what
ROLLUP By Time ROLLUP By Product → year, quarter, month division, brand, item year, quarter division, brand year division all times all products Note that as you increase the number of dimensions and levels, the number of groups to calculate increases dramatically. This example involves 16 groups, but if you were to add just two more dimensions with the same number of levels, you would have 4 x 4 x 4 x 4 = 256 different groups. Also,
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 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
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
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
Column Capacity in ROLLUP and CUBE → CUBE, ROLLUP, and GROUPING SETS do not restrict the GROUP BY clause column capacity. The GROUP BY
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
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 and a grand total. The ROLLUP function is a simple extension to the … GROUP BY clause, so its syntax is easy to use. The ROLLUP function is highly efficient, adding minimal … overhead to a query.The
USER_ADVISOR_SQLA_REC_SUM → displays recommendation rollup information for the workload objects owned by the current user. Its
GROUPING → superaggregate rows from regular grouped rows. GROUP BY extensions such as ROLLUP and CUBE produce … \"Average Sal\" FROM employees e, departments d WHERE d.department_id = e.department_id GROUP BY 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
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
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 → SELECT statement that contains a GROUP BY extension, such as ROLLUP or CUBE, and a GROUPING function
Composite Columns → groupings. You specify the columns in parentheses as in the following statement: ROLLUP (year … unit. In general, composite columns are useful in ROLLUP, CUBE, GROUPING SETS, and concatenated … groupings. For example, in CUBE or ROLLUP, composite columns would mean skipping aggregation across certain … levels. That is, the following