I recently created an Apex application for a fun project, which gave me the chance to install Apex on windows EC2. Here are the steps I followed to install Apex, having decided to use ORDS (Web Listener) to run Apex. The version of Oracle Application Express I used is...
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...
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...