Results for GROUP_ID


1 to 20 of 23 results. Prev  Next


SQL Reference, 9i Release 2 (9.2.0.2)

Functions, 50 of 177

GROUP_IDSyntax group_id::= Text description of group_id Purpose GROUP_ID distinguishes duplicate groups … for a particular grouping, then GROUP_ID returns numbers in the range 0 to n -1. Examples The … (s.amount_sold) \"Revenue\", GROUP_ID() g FROM sales s, customers c, countries co WHERE s.cust_id = c.cust_id

Data Warehousing Guide, 9i Release 2 (9.2.0.2)

SQL for Aggregation in Data Warehouses

GROUP_ID Functionthat can include duplicate groupings. The GROUP_ID function lets you distinguish among duplicate … groupings. If there are multiple sets of rows calculated for a given level, GROUP_ID assigns the value … a duplicate grouping: Example 18-9 GROUP_ID SELECT country_id, cust_state_province, SUM(amount_sold … ), GROUPING_ID(country_id,

SQL Reference, 9i Release 2 (9.2.0.2)

Functions, 2 of 177

FIRSTGROUP_ID

Data Warehousing Guide, 9i Release 2 (9.2.0.2)

Oracle9i Data Warehousing Guide -- Index

Grange, 5-3 partition, 5-4 GROUP_ID function, 18-17 grouping grouping compatibility check, 22-40

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

Sample Usage

Example: Group-Related FunctionsDBMS_LDAP_UTL.HANDLE; group_id VARCHAR2(2000); group_type PLS_INTEGER; user_handle DBMS_LDAP_UTL.HANDLE … =user1,cn=users,o=acme,dc=com'; group_type:= DBMS_LDAP_UTL.TYPE_DN; group_id:= 'cn=group1,cn=groups … ,group_id); IF retval != DBMS_LDAP_UTL.SUCCESS THEN -- Handle Errors DBMS_OUTPUT.PUT_LINE

Workflow Guide (Oracle Workflow Help), 9i Release 2 (9.2.0.2)

WF_NOTIFICATION_ATTR_RESP_V (Oracle Workflow Help)

WF_NOTIFICATION_ATTR_RESP_VNull? Type ------------------------------- -------- ---- GROUP_ID NOT NULL NUMBER RECIPIENT_ROLE NOT

Data Warehousing Guide, 9i Release 2 (9.2.0.2)

Oracle9i Data Warehousing Guide -- Index

Ffunctions COUNT, 6-5 CUME_DIST, 19-13 DENSE_RANK, 19-5 FIRST_VALUE, 19-24 FIRST/LAST, 19-28 GROUP_ID

Reference, 9i Release 2 (9.2.0.2)

Dynamic Performance (V$) Views, 69 of 238

V$GES_BLOCKING_ENQUEUEbelongs to GROUP_ID NUMBER Group identifier for the lock OPEN_OPT_DEADLOCK NUMBER 1 if DEADLOCK open

SQL Reference, 9i Release 2 (9.2.0.2)

Oracle9i SQL Reference -- Index

Gconditions, 5-7 GROUP_ID function, 6-72 GROUPING function, 6-74 grouping sets, 18-23 GROUPING SETS clause

Reference, 9i Release 2 (9.2.0.2)

Dynamic Performance (V$) Views, 72 of 238

V$GES_ENQUEUEidentifier to which the lock belongs GROUP_ID NUMBER Group identifier for the lock OPEN_OPT_DEADLOCK NUMBER 1

Data Warehousing Guide, 9i Release 2 (9.2.0.2)

SQL for Aggregation in Data Warehouses

Concatenated Groupingsfilter out the extra ( channel_desc ) group, the query could use a GROUP_ID function. Another

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

The DBMS_LDAP_UTL PL/SQL Package

Group-Related Subprograms, group_type IN PLS_INTEGER, group_id IN VARCHAR2 ) RETURN PLS_INTEGER; Parameters Table 7-27 … , DBMS_LDAP_UTL.TYPE_NICKNAME group_id VARCHAR2 The group ID representing the group entry. Return Values

SQL Reference, 9i Release 2 (9.2.0.2)

Oracle9i SQL Reference -- Contents

Oracle9i SQL Reference -- ContentsGROUP_ID GROUPING GROUPING_ID HEXTORAW INITCAP INSTR LAG LAST LAST_DAY LAST_VALUE LEAD LEAST LENGTH LN

New Features, 9i Release 2 (9.2.0.2)

Oracle9i Database Release 1 (9.0.1) New Features

SQL and PL/SQL ImprovementsCURRENT_TIMESTAMP DBTIMEZONE DECOMPOSE EXISTSNODE EXTRACT (datetime) EXTRACT (XML) FIRST FROM_TZ GROUP_ID

Data Warehousing Guide, 9i Release 2 (9.2.0.2)

Oracle9i Data Warehousing Guide -- Contents

Oracle9i Data Warehousing Guide -- ContentsWhen to Use GROUPING GROUPING_ID Function GROUP_ID Function GROUPING SETS Expression Composite

SQL Reference, 9i Release 2 (9.2.0.2)

SQL Statements: SAVEPOINT to UPDATE, 3 of 8

Examples-10 US 4,802,459 See Also: the functions GROUP_ID, GROUPING, and GROUPING_ID for more information on

SQL Reference, 9i Release 2 (9.2.0.2)

Oracle9i SQL Reference -- Index

S-71 GREATEST, 6-72 GROUP_ID, 6-72 GROUPING, 6-74 GROUPING_ID, 6-75 HEXTORAW, 6-77 INITCAP, 6-77 INSTR

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

Internet Access to Advanced Queuing

IDAP Documentsidentified by group_id timestamp --the time the message was sent, which cannot be specified during

SQL Reference, 9i Release 2 (9.2.0.2)

SQL Statements: SAVEPOINT to UPDATE, 3 of 8

Semanticsgrouping syntax for data aggregation the GROUP_ID, GROUPING, and GROUPING_ID functions for examples

Generic Documentation Master Index, 9i Release 2 (9.2.0.2)

Oracle9i Database Master Index: G (Release 2 (9.2))

Oracle9 i Database Master Index: G (Release 2 (9.2))) GROUP_ID function (SQL Reference)       [entry #2] (Data Warehousing Guide) GROUP_READ function (Label





Was this page helpful?

Integrated Cloud Applications & Platform Services