Pivoting in SQL using the 10g Model Clause
In this post we discuss pivoting of records in SQL - either splitting or merging records. Typically this is done using PL/SQL based Table Functioins, UNION (for splitting records) …
Category: Data Analytics
For our eyes only – Oracle EPB (Enterprise Planning & Budgeting)
Last Friday we enjoyed one of the special privileges we have in our partnership with Oracle in The Netherlands – we have a private session on one of Oracle’s …
Parallelizing Table Functions (instead of paralysing)
![Parallelizing Table Functions (instead of paralysing)]({"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"http:\/\/seattletimes.nwsource.com\/ABPub\/2012\/08\/02\/2018836700.jpg","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0"} "Parallelizing Table Functions (instead of paralysing)")
In this post I explore the parallel execution of Table Functions. I was told it could be done, I have seen the examples and now I have tried it …
Oracle (finally) announced release of Enterprise Planning and Budgeting
From both the Oracle website as well as Mark Rittman’s weblog the release of Oracle’s new enterprise level Business Intelligence product Enterprise Planning and Budgetting was announced. This tool …