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).
http://blogs.techrepublic.com.com/datacenter/?p=130&tag=nl.e050
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:
http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14223/sqlmodel.htm
Tuesday, March 25, 2008
The MODEL clause of the SELECT statement Oracle 10G
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment