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...
Gartner sure did throw the cat amongst the pigeons last month, Shane called it a "blood bath", others applauded a coming of age for BI, everyone noted Oracle's absence - big time. I am, of course, referring to the Magic Quadrant on Business Intelligence and Analytics...
I’m an Oracle fanboy. When I say fanboy, I mean, if I had to pick my preferred relational database, it would be Oracle. This isn’t because I necessarily think it’s better, faster or easier to use, but rather because it was my first. I’m also lucky enough to have used...
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...
When I search for SAS Access to Oracle I tend to find a lot of information on how to code my SAS script, what engine to use and some of the options available, but details on the configuration are few and far between. So, I thought I would write a blog about each one...
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...