Generating Rows Automatically in Oracle
Generating Rows Automatically in Oracle Quite often there is a need to generate rows in SQL. Whether it be to …
Best Practices – Extending E-Business Suite with Oracle Application Express (APEX)
This post follows on from a previous post which describes how to seamlessly integrate your APEX and E-Business Suite environments …
Extending E-Business Suite with Oracle Application Express (APEX)
Traditionally E-Business Suite projects have consisted of a number of technologies – Oracle Forms, OAF, Reports, XMLP, SQL*PLUS and so …
SQL and PL/SQL Mistakes, Misunderstandings and Misconceptions – Part 2
If you missed part 1 then you can find it here. In this post I’ll be focussing on a somewhat common …
Prune Days on an E-Business Suite Source Environment
Prune days… often misunderstood, often just left “as default”. Possibly not helped by the fact that entering the search term …
Star Transformations with Bitmap Indexes
One area of data warehousing that often confuses people (typically those who have come from an OLTP development background) is …
SQL and PL/SQL Mistakes, Misunderstandings and Misconceptions – Part 1
I wasn’t too sure of what title to use for this blog post. I wanted to share some things that …
Aggregation Based on Dimensions in OBIEE
The Business Model in OBIEE allows for measures to be aggregated using a variety of different functions. For most scenarios …
External Tables from Shell Scripts
Here’s a little example of something I found quite interesting, and which you generally don’t see being used every day… …