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 SELECT
statements.
SELECT
statements against these SQL views. This method requires minimum knowledge of the underlying data in the analytic workspace.SELECT
statements. 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.
|
Copyright © 2001, 2002 Oracle Corporation. All Rights Reserved. |
|