Skip Headers

Oracle9i OLAP User's Guide
Release 2 (

Part Number A95295-02
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page

Go to previous page Go to next page
View PDF


The OLAP_TABLE function extracts data from the LOBs in which workspace data has been stored and presents the result set in the format of a relational table. OLAP_TABLE is an implementation of the PL/SQL table functions.

The OLAP_TABLE function can be used in a SQL SELECT statement instead of, or in addition to, the names of relational tables and views. It presents fully solved data that is either stored or calculated in an analytic workspace. OLAP_TABLE accepts parameters that are passed to the OLAP engine, which selects, manipulates, and returns the data. The WHERE clause of a SELECT statement that includes a call to OLAP_TABLE only needs to identify the result set; it does not need to perform any calculations. If it does include calculations, they will be performed by the SQL engine, not the OLAP engine.

SELECT statements that use OLAP_TABLE can be used during database maintenance to create relational views, and they can be used interactively to fetch data directly into an application.

See Also:

PL/SQL User's Guide and Reference for a discussion of PL/SQL table functions.