Gauges in APEX can look Gaugaustic!

Oracle APEX is a very suitable RAD tool for quickly creating efficient database-centric web applications. We all know that and that’s what we mostly use it for. I’ve come across some comments here and there about using APEX as a replacement for dashboards. Ever since the introduction of Oracle JET Charts in APEX 5.1+, having interactive dashboards is not far-fetched anymore. Although Oracle JET provides a whole lot of functionality, it’s no very complete. Based on the requirement I had which needed Dynamic gauges to be created, I decided to integrate the D3 JavaScript library into APEX. After doing so, I created an APEX plugin for these gauges for public use. I intend on introducing this plugin in this blog post.

Continue reading “Gauges in APEX can look Gaugaustic!”

42,421 total views, 32 views today

Checkboxes in Interactive Reports – Passing them via AJAX – Oracle APEX


Having multiple details for a master table on a single page is pain. Imagine if each of those details each has another detail or two. It’s a chain of never ending suffering. Especially when you’re doing it all on a single page and all the interactivity is done via simple Interactive Reports and popup Forms. A problem that usually arises is that when you want to delete/update multiple rows in an interactive report and use checkboxes for selecting those rows, once the page is submitted you lose control of which rows you had selected. This can all be implemented using Branches and Page Load Dynamic Actions, but why go through all the hassle?

Continue reading “Checkboxes in Interactive Reports – Passing them via AJAX – Oracle APEX”

54,944 total views, 27 views today

Timers in Oracle APEX – Retro Style!

Retro Clock

I’m back with another plugin. A customer of mine had a requirement to show a classy timer on a form so that the people filling in the forms knew how much time they had been spending filling in the super long form. I initially did it precisely for that case, but they liked it too much and wanted ┬áthe timers on a whole lot of pages. That’s what pushed me to turn it into a simple plugin so that our other developers with less knowledge of JavaScript/jQuery could benefit from it too.

Continue reading “Timers in Oracle APEX – Retro Style!”

43,600 total views, 24 views today

Notifications Done Right – ApexNoti – Oracle APEX Browser Notifications

ApexNoti Notifications

Ever wanted to have proper looking “browser” notifications? Well this plugin might help you out. You might have seen these notifications before when something goes wrong with a certain browser extension (e.g. it crashes). Or sometimes when a new extension is added.

Continue reading “Notifications Done Right – ApexNoti – Oracle APEX Browser Notifications”

44,123 total views, 23 views today

Screensaver Effect in Oracle APEX Pages

Well, I’m back again, with a little feature that adds add an interesting screensaver effect to your pages and somehow brings them to life.

Ever wanted to have that inactive sign-out timer? Well this post may help you achieve that.

All you need to do is include a javascript file (.js) in your application any way that you host your external files. This file must include the code below :

Continue reading “Screensaver Effect in Oracle APEX Pages”

12,237 total views, no views today

Printing Barcodes Using Oracle BI Publisher and Oracle APEX

I came across a user requirement today. The requirement was to print out some numbers as barcodes using our printing server (Oracle BI Publisher).

There were many different proposed ways when I googled, but the best one I stumbled upon was the “Font Mapping” option in the BI Publisher Administration Panel.

Continue reading “Printing Barcodes Using Oracle BI Publisher and Oracle APEX”

10,890 total views, 7 views today