Author: Jorge Rimblas
Hi, I'm Jorge Rimblas. Father, husband, photographer, Oraclenerd, Oracle APEX expert, Oracle ACE, coffee lover, car guy, gadget addict, etc... I'm a Senior APEX Consultant with Insum Solutions, a consulting firm specialized in Oracle databases and the APEX development tool. I have worked with Oracle since 1995 and done eBusiness Suite implementations and customizations. Nowadays I specialize almost exclusively in Oracle APEX.

Video: Part 1- APEX Classic Report Named Column Templates

As part of my Kscope16 presentation “Hooked on Classic (Reports) Learn tips & techniques to make them sing” (live slides here). I demoed a Classic Report with a custom template (a Named Column template), made to look like a list.

Posted in APEX, Classic Reports, KScope, Oracle, Video


You may be familiar with the UNION operator in Oracle SQL, but are aware of the UNION ALL operator? Perhaps you will be surprised to hear that more often than not when you write UNION, what you meant to use

Posted in Oracle

Winds of Change

After three and half years at Enkitec, the last 1.5 of those years as Accenture Enkitec Group, it’s now time to make a change. It has been a great ride with a lot of highs, success, and accomplishments. I couldn’t

Posted in Uncategorized

Using Select2 on APEX tabular forms

I love the Select2 jQuery plugin. It’s a feature rich, good looking, select list replacement. As an APEX developer, it makes sense to use the excellent plugin from Nick Buytaert. Since its announcement, in Aug 2013, you would be hard

Posted in APEX, Javascript, Oracle, Plugins

Fill the Glass: Measuring Software Performance

I had the delight of participating on a “Fill The Glass” webinar (#FillTheGlass). Fill the Glass is a new style of, technology related, webinar series by Cary Millsap. Cary Millsap is a developer, teacher, writer, and consultant who has been

Posted in APEX, Interviews, Oracle, Video

Expert Oracle Application Express 2nd Edition

I’m really excited to share with you that the 2nd Edition of APRESS Expert Oracle Application Express (Amazon link) is now released. Some of the concepts in this book may apply to previous versions of APEX, but this book was created with

Posted in APEX, Oracle

Enhancement to waitPopup on APEX5

APEX 5 has a nifty nice enhancement to the use of apex.widget.waitPopup. It now returns a “remove” function you can call to remove the wait indicator.

The Details I’ve used apex.widget.waitPopup many times. You simply call it like this:

Posted in APEX, API, Javascript, Oracle

12c WITH inline PL/SQL, json_from_sql, Bind Variables and AJAX

I recently got to use a new cool feature in Oracle 12c R1, the WITH clause with inline PL/SQL (read more at oracle-base). Then Scott Wesley blogged about it and I made a comment on twitter. But don’t stop reading

Posted in 12c, APEX, JSON, Oracle

HSL color format rocks!

Do you struggle finding a suitable color for a hover state or a selected item? If yes, read on. Check out this simple example. You’ll see the color represented in the usual RGB hex values and in HSL. The HSL

Posted in APEX, KScope, Oracle, Web

SharePoint to Oracle data conversion

The purpose of this post is to document the process I used to convert the data from a Microsoft SharePoint site to an Oracle database with an APEX front end.  However, there won’t be much about APEX in this post, sorry.

Posted in APEX, Conversion, Oracle, Technology