You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. 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
Results for ROLLUP


1 to 20 of 153 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


Database Data Warehousing Guide, 11g Release 2 (11.2)

SQL for Aggregation in Data Warehouses

ROLLUP SyntaxROLLUP 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,

Database Data Warehousing Guide, 11g Release 2 (11.2)

SQL for Aggregation in Data Warehouses

Partial RollupYou 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',

Database Data Warehousing Guide, 11g Release 2 (11.2)

Advanced Query Rewrite

Aggregate RollupIf 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

Database Data Warehousing Guide, 11g Release 2 (11.2)

SQL for Aggregation in Data Warehouses

ROLLUP By Time ROLLUP By Product ROLLUP By Geographyspecified 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

Database Data Warehousing Guide, 11g Release 2 (11.2)

Advanced Materialized Views

ROLLUP By Time ROLLUP By Productyear, 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,

Database Data Warehousing Guide, 11g Release 2 (11.2)

SQL for Aggregation in Data Warehouses

When to Use ROLLUPUse 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

Database Data Warehousing Guide, 11g Release 2 (11.2)

Advanced Query Rewrite

Rollup Using a DimensionWhen 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

Database Data Warehousing Guide, 11g Release 2 (11.2)

SQL for Aggregation in Data Warehouses

ROLLUP Extension to GROUP BYROLLUP 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

Database Data Warehousing Guide, 11g Release 2 (11.2)

SQL for Aggregation in Data Warehouses

Hierarchy Handling in ROLLUP and CUBEThe 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

Database Data Warehousing Guide, 11g Release 2 (11.2)

SQL for Aggregation in Data Warehouses

Column Capacity in ROLLUP and CUBECUBE, ROLLUP, and GROUPING SETS do not restrict the GROUP BY clause column capacity. The GROUP BY

Database Data Warehousing Guide, 11g Release 2 (11.2)

SQL for Aggregation in Data Warehouses

Using Other Aggregate Functions with ROLLUP and CUBEThe examples in this chapter show ROLLUP and CUBE used with the SUM function. While this is the

Database Data Warehousing Guide, 11g Release 2 (11.2)

SQL for Aggregation in Data Warehouses

Considerations when Using AggregationThis 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

Database 2 Day + Data Warehousing Guide, 11g Release 2 (11.2)

SQL for Reporting and Analysis

How to Add Totals to Reports Using the ROLLUP FunctionThe 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

Database Reference, 11g Release 2 (11.2)

USER_ADVISOR_SQLA_REC_SUM

USER_ADVISOR_SQLA_REC_SUMdisplays recommendation rollup information for the workload objects owned by the current user. Its

Database SQL Language Reference, 11g Release 2 (11.2)

GROUPING

GROUPINGsuperaggregate 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

Database Data Warehousing Guide, 11g Release 2 (11.2)

SQL for Aggregation in Data Warehouses

Specifying Hierarchical Cubes in SQLconcatenated 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

Database Data Warehousing Guide, 11g Release 2 (11.2)

SQL for Aggregation in Data Warehouses

Overview of SQL for Aggregation in Data Warehouseswarehouse, 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

Database SQL Language Reference, 11g Release 2 (11.2)

STATS_T_TEST_*

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

Database SQL Language Reference, 11g Release 2 (11.2)

GROUPING_ID

GROUPING_IDSELECT statement that contains a GROUP BY extension, such as ROLLUP or CUBE, and a GROUPING function

Database Data Warehousing Guide, 11g Release 2 (11.2)

SQL for Aggregation in Data Warehouses

Composite Columnsgroupings. 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