Tuesday, March 25, 2008

The MODEL clause of the SELECT statement Oracle 10G

The MODEL clause of the SELECT statement enables you to treat your relational output like a spreadsheet. The MODEL clause identifies which columns to aggregate (measures), which columns serve as unique array indexes (dimensions), and which formulas calculate the values (rules).


The MODEL clause has many options for calculating data beyond what is shown here. For more information on MODEL, see the Oracle Database Data Warehousing Guide, Chapter 22, SQL for Modeling:

No comments: