|Oracle® OLAP DML Reference
10g Release 1 (10.1)
Part Number B10339-02
The Oracle OLAP DML Reference provides a complete description of the OLAP Data Manipulation Language (OLAP DML) used to define and manipulate analytic workspace objects. Part I briefly describes how to use the OLAP DML. Part II consists of a reference topic for each of the OLAP DML statements.
This manual is intended for programmers and database administrators who create and modify analytic workspaces and analytic workspace objects using the OLAP DML.
Our goal is to make Oracle products, services, and supporting documentation accessible, with good usability, to the disabled community. To that end, our documentation includes features that make information available to users of assistive technology. This documentation is available in HTML format, and contains markup to facilitate access by the disabled community. Standards will continue to evolve over time, and Oracle is actively engaged with other market-leading technology vendors to address technical obstacles so that our documentation can be accessible to all of our customers. For additional information, visit the Oracle Accessibility Program Web site at
JAWS, a Windows screen reader, may not always correctly read the code examples in this document. The conventions for writing code require that closing braces should appear on an otherwise empty line; however, JAWS may not always read a line of text that consists solely of a bracket or brace.
This documentation may contain links to Web sites of other companies or organizations that Oracle does not own or control. Oracle neither evaluates nor makes any representations regarding the accessibility of these Web sites.
This document is structured in the following three parts.
Introduces the basic concepts of analyzing data using the OLAP DML.
Consists of a topic for each of the OLAP DML statements, arranged alphabetically. Each topic provides a description, syntax, notes, and example for an OLAP DML statement.
Provides summary information about OLAP DML statements.
The following documents provide additional information about using Oracle OLAP:
Explains how SQL and Java applications can extend their analytic processing capabilities by using Oracle OLAP in the Enterprise Edition of Oracle Database.
Explains the syntax of PL/SQL packages and types and the column structure of views related to Oracle OLAP.
Introduces the Oracle OLAP API, a Java application programming interface for Oracle OLAP, which is used to perform online analytical processing of the data stored in an Oracle database. Describes the API and how to discover metadata, create queries, and retrieve data.
Describes the classes and methods in the Oracle OLAP Java API for querying analytic workspaces and relational data warehouses.
Describes the classes and methods in the Oracle OLAP Java API for building and maintaining analytic workspaces.
The following conventions are used in this manual.
|...||Horizontal ellipsis points in examples mean that information not directly related to the example has been omitted.
Horizontal ellipsis points in syntax indicate a repeating argument or clause.
|boldface text||Boldface type in text indicates a term defined in the text.|
|italic text||Italicized type in text indicates emphasis.
Italicized type in syntax indicates or a user-supplied name.
||Brackets in syntax enclose optional clauses from which you can choose one or none.|
||Braces in syntax enclose required clauses from which you must chose one.|