« Oracle Accounts for 80.5 Percent of New License Sales in Linux | Open Source BI » |
For those doing data warehousing in Oracle, the MODEL Clause proves to be a powerful extension to SQL in Oracle 10g. The MODEL clause enables one to create a multidimensional array by mapping the columns of a query into three groups: partitioning, dimension, and measure columns.
Here are some good and useful resources on how to use the MODEL Clause:
And of course, there's the most useful one for me ...
Oracle® Documentation
Related References:
Oracle Database 10g: The Complete Reference
Oracle Database 10g PL/SQL Programming