| Oracle® OLAP DML Reference 11g Release 1 (11.1) Part Number B28126-01 |
|
|
View PDF |
| Oracle® OLAP DML Reference 11g Release 1 (11.1) Part Number B28126-01 |
|
|
View PDF |
The $GID_TYPE property, which is automatically created and set when a GROUPINGID command with either the ROLLUP or GROUPSET keyword populates a grouping id relation, specifies whether the grouping type of the grouping ids.
Syntax
You can not explicitly define a $GID_TYPE property. Oracle OLAP automatically creates a $GID_TYPE property on a grouping id relation when the execution of a GROUPIONGID command with either the ROLLUP or GROUPSET keyword creates the relation.
$GID_TYPE = ROLLUP | GROUPSET
Arguments
Specifies that the grouping ids are of the rollup type. For more information on this type of grouping type, see the discussion of ROLLUP in the GROUPBY clause of a SQL SELECT statement in the Oracle Database SQL Language Reference.
Specifies that the grouping ids are of the grouping set type. For more information on this type of grouping type, see the discussion of grouping sets in the GROUPBY clause of a SQL SELECT statement in the Oracle Database SQL Language Reference.
