|Oracle9i OLAP Developer's Guide to the OLAP DML
Release 2 (9.2)
Part Number A95298-01
Basic Concepts, 5 of 6
SQL programmers can query data in the analytic workspace using SQL
SELECT statements that use OLAP table functions and by embedding OLAP DML commands in their SQL scripts. The Oracle9i OLAP User's Guide describes these activities.
SQL programmers can query analytic workspace data using SQL
SELECTstatements against these SQL views. This method requires minimum knowledge of the underlying data in the analytic workspace.
SELECTstatements. This method requires intimate knowledge of the analytic workspace data. The OLAP_TABLE function is provided with Oracle OLAP.
Using the procedures and functions in the DBMS_AW package, SQL programmers can issue OLAP DML statements against analytic workspace data. They can move data from relational tables into an analytic workspace, perform advanced analysis of the data (for example, forecasting), and move data from the analytic workspace back into relational tables.