Statements Used Primarily in Programs |
Table: Statements Used Primarily in OLAP DML Programs lists the OLAP DML statements that are used primarily in OLAP DML programs.
Statements Used Primarily in OLAP DML Programs
| Statement | Description |
|---|---|
| ACROSS
|
Specifies a text expression that contains one or more statements to be executed in a loop. |
| CONTEXT command
|
Lets you create and use a context during your Oracle OLAP session. A context is a means of preserving object values. After you create a context, you can save the current status of dimensions and the values of options, single-cell variables, valuesets, and single-cell relations in the context. You can then restore some or all of the object values from the context. |
| CONTEXT function
|
Obtains information about object values that are saved in a context. You must first create the context with the CONTEXT command. |
| INFO (PARSE) | Obtains information that has been produced by the PARSE command. |
| PARSE
|
Parses a specified group of expressions. |
| POP
|
Restores the status of a dimension, the status of a valueset, or the value of an option or single-cell variable that was saved with a previous PUSH command. |
| POPLEVEL
|
Restores all values saved with PUSH commands that were executed since the last POPLEVEL command specifying the same marker. |
| PUSH
|
Saves the current status of a dimension, the status of a valueset, or the value of an option or single-cell variable. |
| PUSHLEVEL
|
Marks the start of a series of PUSH commands. |
| SLEEP
|
Suspends the operation of Oracle OLAP for at least the specified number of seconds. |