Tuesday, September 13, 2005

On Oracle10G Model Clause--Powerful Spreadsheet like Calculations inside database

ORACLE 10G SQL Enhancement Model Clause
Having gone through the feature summary and an example from AskTom Website , it looks to me that
Oracle is trying to eliminate the need for spreadsheet programs which are used to do some inter-row calculations on the results fetched from the database. Looks impressive along with the analytic functions which Oracle has introduced on the SQL arena: For those who want to read the feature summary here is the link for the pdf(Thanks to Thomas Kyte) http://www.oracle.com/technology/products/bi/pdf/10gr1_twp_bi_dw_sqlmodel.pdf

No comments: