| Oracle® OLAP DML Reference 10g Release 1 (10.1) Part Number B10339-02 |
|
|
View PDF |
| Oracle® OLAP DML Reference 10g Release 1 (10.1) Part Number B10339-02 |
|
|
View PDF |
Table A-30, "Statements Related to OLAP_TABLE " lists the OLAP DML statements that support the use of the OLAP_TABLE function.
Table A-30 Statements Related to OLAP_TABLE
| Statement | Description |
|---|---|
| FETCH |
Specifies how analytic workspace data is retrieved for use in the relational table created by the OLAP_TABLE function which you use to access analytic workspace data using SQL. |
| GROUPINGID |
Populates a previously-defined variable with the grouping ids for the values of a hierarchical dimension. |
| HIERHEIGHT command | Populates a previously-defined relation with the values of a specified hierarchical dimension by level. |
| LIMITMAPINFO
|
Returns the analytic workspace expression that a specified limit map uses to map data into a specified column of a relational table. |
|
 Copyright © 2003 Oracle Corporation All Rights Reserved. |
|
