Blog Archives

UNION or UNION ALL

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

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

A wireframe is worth a 1000 words

I better get this out of the way. I love Balsamiq Mockups! There, I said it. This post will probably sound like an advertisement, but it’s not. It’s unsolicited and I paid for my own version of Balsamiq. However, for

Posted in APEX, Mockups, Oracle, Technology, Web

Oracle APEX

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.