Results for GROUPING


1 to 20 of 228 results. Prev  Next
Results per page:   20  | 40 | 60


SQL Reference, 9i Release 2 (9.2.0.2)

Functions, 51 of 177

GROUPINGSyntax grouping::= Text description of grouping Purpose GROUPING distinguishes superaggregate rows … where the set of all values is represented by . Using the GROUPING function, you can distinguish … expr in the GROUPING function must match one of the expressions in the GROUP BY clause. The function

SQL Reference, 9i Release 2 (9.2.0.2)

Functions, 2 of 177

GROUPING_ID

OLAP User's Guide, 9i Release 2 (9.2.0.2)

OLAP_TABLE, 3 of 6

Grouping IDsby using the GROUPINGID command in the OLAP DML. Grouping IDs are used by the OLAP API to improve

Data Warehousing Guide, 9i Release 2 (9.2.0.2)

SQL for Aggregation in Data Warehouses

GROUPING FunctionGROUPING handles these problems. Using a single column as its argument, GROUPING returns 1 when it … row is a subtotal, GROUPING returns a 1. Any other type of value, including a stored NULL, returns a 0 … . GROUPING Syntax GROUPING appears in the selection list portion of a SELECT statement. Its form

Data Warehousing Guide, 9i Release 2 (9.2.0.2)

SQL for Aggregation in Data Warehouses

GROUPING FunctionsTwo challenges arise with the use of ROLLUP and CUBE. First, how can you programmatically determine which result set rows are subtotals, and how do you find the exact level of aggregation for a given subtotal? You often need to use subtotals in calculations such as percent-of-totals, so you need an easy way to determine which rows are the subtotals. Second, what happens if query results contain both

Application Developer's Guide - Advanced Queuing, 9i Release 2 (9.2.0.2)

Introduction to Oracle Advanced Queuing

Message Groupinggrouping. All messages belonging to a group have to be created in the same transaction and all messages … details, followed by the trailer message. To see this feature applied in the context of the BooksOnLine scenario, refer to \"Message Grouping\".

Application Developer's Guide - Advanced Queuing, 9i Release 2 (9.2.0.2)

A Sample Application Using AQ

Message Groupingtransactional message grouping (see \"Creating a Queue Table\" in ChapterĀ 9, \"Administrative Interface\" ). All … , followed by the trailer message. Message grouping is also useful if the message payload contains … properties are specified for subsequent messages in the group. The message grouping property is … have to be propagated

Application Developer's Guide - Advanced Queuing, 9i Release 2 (9.2.0.2)

Creating Applications Using JMS

Message Groupingtransactional message grouping (see \"Creating a Queue Table\", ChapterĀ 9, \"Administrative Interface … message. Message grouping is also very useful if the message payload contains complex large objects … specified for subsequent messages in the group. The message grouping property is preserved across … propagated must also be

Reference, 9i Release 2 (9.2.0.2)

Special Characters in Queries

Grouping CharactersThe grouping characters control operator precedence by grouping query terms and operators in a … query expression. The grouping characters are: Grouping Character Description ( ) The parentheses … indicated by an open character from one of the sets of grouping characters. The ending of a group is

OLAP User's Guide, 9i Release 2 (9.2.0.2)

OLAP_TABLE, 3 of 6

Parent Grouping IDsParent grouping IDs provide the GID value of the parent of each dimension member. OLAP_TABLE … calculates the parent grouping IDs from the member grouping IDs. Thus, you do not need to define the

OLAP User's Guide, 9i Release 2 (9.2.0.2)

Creating an Analytic Workspace From Relational Tables, 7 of 8

Grouping ID ColumnThe GID identifies the hierarchy level associated with each row by assigning a zero to each non- value and a one to each value in the level columns. The resulting binary number is the value of the GID. For example, a GID of 1 is assigned to a row with the following three levels. TOTAL_US REGION STATE -------- ------ ----- USA Southwest 0 0 1 A GID of 3 is assigned to a row with the following five

Globalization Support Guide, 9i Release 2 (9.2.0.2)

OCI Programming in a Global Environment

OCI_NLS_NUMGROUPING : Number grouping fieldsOCI_NLS_LISTSEP: List separator

Data Warehousing Guide, 9i Release 2 (9.2.0.2)

SQL for Aggregation in Data Warehouses

When to Use GROUPINGThe GROUPING function is not only useful for identifying NULLs, it also enables sorting subtotal … and none of the base-level aggregations. The HAVING clause constrains columns that use GROUPING … functions. Example 18-8 GROUPING Combined with HAVING SELECT channel_desc, calendar_month_desc … , country_id, TO_CHAR(SUM(amount_sold),

Application Developer's Guide - Fundamentals, 9i Release 2 (9.2.0.2)

How Oracle Processes SQL Statements

Grouping Operations into TransactionsIn general, only application designers using the programming interfaces to Oracle are concerned with which types of actions should be grouped together as one transaction. Transactions must be defined properly so that work is accomplished in logical units and data is kept consistent. A transaction should consist of all of the necessary parts for one logical unit of work, no more and no less. Data in

Data Warehousing Guide, 9i Release 2 (9.2.0.2)

SQL for Aggregation in Data Warehouses

GROUPING SETS ExpressionYou can selectively specify the set of groups that you want to create using a GROUPING SETS … ('2000-09', '2000-10') AND country_id IN ('UK', 'US') GROUP BY GROUPING SETS((channel_desc … ROLLUP can be thought of as grouping sets with very specific semantics. For example, consider the … following statement: CUBE(a, b, c) This statement

OLAP User's Guide, 9i Release 2 (9.2.0.2)

CWM2_OLAP_PC_TRANSFORM, 5 of 7

Grouping ID ColumnThe script automatically creates a GID column, as required by the OLAP API. The GID identifies the hierarchy level associated with each row by assigning a zero to each non- value and a one to each value in the level columns. The resulting binary number is the value of the GID. For example, a GID of 3 is assigned to the row with the level values World, USA, Northeast, since the three highest levels

Globalization Support Guide, 9i Release 2 (9.2.0.2)

OCI Programming in a Global Environment

OCI_NLS_MONGROUPING : Monetary grouping fieldsOCI_NLS_INT_CURRENCYSEP: International currency separator

Data Warehousing Guide, 9i Release 2 (9.2.0.2)

Query Rewrite

Query Rewrite Considerations: Grouping Conditionsmore space. For example, instead of grouping on state, group on city (unless space constraints … dimension. For example, instead of grouping on prod_name, group on prod_id (as long as there is a

Application Developer's Guide - Advanced Queuing, 9i Release 2 (9.2.0.2)

Oracle Advanced Queuing by Example

Enqueuing and Dequeuing of Messages Using Message Grouping Using PL/SQLCONNECT aq/aq EXECUTE DBMS_AQADM.CREATE_QUEUE_TABLE ( queue_table => 'aq.msggroup', queue_payload_type => 'aq.message_typ', message_grouping => DBMS_AQADM.TRANSACTIONAL); EXECUTE DBMS_AQADM.CREATE_QUEUE( queue_name => 'msggroup_queue', queue_table => 'aq.msggroup'); EXECUTE DBMS_AQADM.START_QUEUE( queue_name => 'msggroup_queue'); /* Enqueue three messages in each transaction */ DECLARE enqueue_options

OLAP User's Guide, 9i Release 2 (9.2.0.2)

Creating Fact Materialized Views With DBMS_ODM, 2 of 9

Procedure: Create and Run Scripts to Generate Grouping Set Materialized ViewsFollow these steps to create a grouping set materialized view for a cube: Create and map a valid … create a script to generate a grouping set materialized view for the cube: Execute


Was this page helpful?