In this blog, I'll walk you through how to create a timer item in your Oracle Apex application. In this example, I am creating a timer clock that starts from 00:00 that counts till the page is active. You can make modifications to your timer item to match your...
I recently started using Oracle Application Express. One of my goals was to understand how to customise the UI to make it beautiful and informative. Every web developer wants their application to be different and unique. It’s no surprise that I wanted my application...
Recently I was asked during an interview how I would approach adopting new features in Oracle as part of an upgrade. At the time I feel I gave a pretty cursory reply and I just explained how I’d performed an upgrade (migration) across platforms and had implemented new...
I'm lazy, why doesn't anyone have instructions I can follow already! I guess it's time to give back to the Google seekers of this world. After going through the process I can understand why no one has written a guide, it's not a straight forward process. As this sort...
It's always nice to dip your toes in the familiar with Oralce Apex 5 being out for over a year now I thought I'd validate an old blog I wrote about running Apex in the Cloud. Oracle do provide cloud options if you just want to try it out but like any tech geek I...
Oracle have been catching up in the analytics space. One of the features they had been lacking was in regards to self-service analytics. Basically, the ability for a user to mashup their own data with corporate data. I believe it's the reason why they didn't feature...
I'm Ben Lee I'm into report development, data integration and data modelling. In this blog I explain how I helped a customer manage their own help text. Recently I had the scenario where a customer wanted to be able to manage their own help text for a page in an...
In Clean Code, Martin recommends that: The ideal number of arguments for a function is zero (niladic). Next comes one (monadic), followed closely by two (dyadic). Three arguments (triadic) should be avoided where possible. More than three (polyadic) requires very...
By default Oracle Data Integrator (ODI) 11g uses the “old-style” join syntax when joining tables. While many Oracle developers still prefer that style of join, I for one find ANSI joins to be far cleaner and easier to read. Oracle started supporting ANSI joins in...
SQL*Loader is an Oracle tool used for loading data into tables from external files. This blog assumes you have some, but not comprehensive knowledge of SQL*Loader. You can do some quick reading of Oracle’s documentation if you are completely unfamiliar. Data Source...