Make even more of UKOUG Tech15: APEX 5.0 UI Training – Dec 10th in Birmingham

APEX 5.0 has been released this spring. People who have already spent some time on this new version know this version is packed with new features aimed to make APEX developers even more productive, like the Page Designer.
Another striking new subset of features is aimed at creating better looking user interfaces for your APEX applications in an easy and maintainable way. 
The definition of user interface components in APEX 5.0 is (more...)

Quick and Dirty – Refreshing a Select List of Values

This is a quick and dirty solution but it works. It shows hot to update a select list of values on demand without a lot of coding.

AJAX Callback and jQuery creating Page Items Dynamically

This example shows a couple of interesting techniques:
  • 1. How to create and use an AJAX Callback process instead of an Application Process on Demand,
  • 2. how to create a dynamic page item,
  • 3. how to modify the item display settings and reference Font Awsome icon set and finaly,
  • 4. it shows how to call an AJAX process from javascript.
This question is based on a recent forum posting where this question was asked.
Have (more...)

APEX Instance debugging on command line

One of many small enhancements in Oracle APEX 5.0 is a small utility that can be used to help debugging an APEX application from SQLPLUS or sqlcl.

When you download and unzip APEX 5 you’ll find a utilities directory which includes a debug directory:

The debug directory contains 4 SQL scripts:

  1. d0.sql
  2. d1.sql
  3. d2.sql
  4. ds.sql

Now lets take a look at what those scripts are doing:


With d0. (more...)

APEX Meetup Frankfurt

Am 26.06.2015 17.00 treffen wir uns in Frankfurt a. M. bei einem weiteren APEX Meetup. Danke an Sabine Heimsath und Moritz Klein für die Organisation. Ich zeige dort, wie man lokal eine XE Datenbank zusammen mit ORDS und Glassfish konfigurieren kann. Danach kann sehr leicht jede beliebige Version von APEX nachinstalliert werden. Der Vorteil ist, ich kann alle Features einsetzen (RESTful Services, XLS Upload) und der Austausch vo Images bzw. Konfiguration für (more...)

APEX Connect 2015 – Review

Die APEX Connect 2015 (#apexconnect15) war die erste ihrer Art in Deutschland. Eine Konferenz bei der es nur um Oracle APEX ging.

Das waren die Fakten:
 - 2 Tage voll gepackt mit Themen rund um Application Express
 - 4 Vortragsstreams
 - Die Konferenz war ausverkauft (rund 250 APEX Enthusiasten)
 - TOP Developer aus dem In- und Ausland

Was sind die Eindrücke die ich mitnehme?
 - Die Organisation rund um das Event war TOP
 - Die (more...)

APEX Connect Presentation and Download of the sample application

Hi guys,

I have just finished my presentation on the smaller new features of Oracle Application Express 5.0 here at the APEX Connect conference in Düsseldorf ... it was a blast :).

You can download the slides and the sample application here:


APEX Connect Vortrag: Plug-Ins maßgerecht verwenden

SAVE THE DATE: Am Dienstag dem 09.06. zwischen 11:00 - 11:45 halte ich meinen Vortrag.

Wie so oft habe ich auch für diesen Vortrag eine individuell zusammengestellte APEX Anwendung entwickelt, anhand dessen ich die Präsentation halten werden.


Der Vortrag eignet sich für Einsteiger wie Fortgeschrittene. Ich werde anhand unterschiedlichster Plug-Ins auf die Vorteile und Gefahren aufmerksam machen.

Also schaut rein und genießt die Show! :)

Ps.: Für Alle die (more...)

APEX 5.0 – Run Applications in New Tabs Part 2

In this blog posting I was showing how to get the Firefox Browser to work with tabs in APEX 5.0. It looks like APEX 5.0 was "optimized" to work in Google Chrome and the other browsers like IE and Firefox were not fully considered. I was able to make it working using the settings I described in the first post. However, the old style popup windows would also open in a new tab. (more...)

Sumner Technologies: Take Two

About a month ago, I left my position at Accenture Enkitec Group. I had a couple of ideas as to what I wanted to do next, but nothing was 100% solid.  After considering a couple of different options, I'm happy to announce that together with Doug Gault & Tim St. Hilaire, we're re-launching Sumner Technologies.

Much like last time, the focus will be on Oracle APEX; but we’re going to refine that focus a little (more...)

APEX Plugins

This may sound like a joke but I think there must be something wrong here. This page is supposed to provide all the plugins out there. The only thing is that you need to log in before you download and that's O.K. However, I forgot my password and wanted to change it. The process is quite simple:
  • I click on forgot my password link.
  • Enter my email address.
  • After that I receive (more...)

Fixing Super LOV in Universal Theme

When you migrate to APEX 5.0 and the Universal Theme you might see that some plugins are not behaving correctly anymore. In this post I'll discuss the Enkitec Modal LOV plugin.

When I ran the plugin in my APEX 5.0 app with the Universal Theme it looked like this:

There's too much space in the search bar and the close button is not showing up with an icon.

Here're the steps I did (more...)

What is the APEX Open Mic Night at Kscope15?

At the upcoming ODTUG Kscope15 conference, on Monday night, June 22, there will be the Monday Community Events.  The Community Event for the Oracle Application Express track at Kscope15 is the ever-popular Open Mic Night.  Without a doubt, this is one of my favorite events at the Kscope conference.

An Oracle employee sent me an email today, inquiring about the Open Mic Night.  This employee, who is a user of Oracle Application Express at Oracle, (more...)

Differences between Oracle APEX 4.2 and 5.0

If you haven’t heard: APEX 5.0 is out !

And I finally got some time on my hands to do my usual “diff” between the new and previous version to point out all API and View changes.

To me this is a very valuable exercise to absorb all new information and to get to know all new Features of a version. Because everything I find in View and API changes, must also be reflected in (more...)

Tabular Form – Add Rows Top – Universal Theme

This old example shows how to add rows to the top of the tabular form. Unfortunately this doesn't work with the new Universal Theme. In order to make it working some small changes are required. See this example on how to do it using the new Universal Theme.


2 minute Tech Tip: Working with JSON in APEX

On Monday Bob Rhubart did a video call with me in his series of 2MTT (2 Minute Tech Tip) on YouTube. You find my 2MMT here.

I talked about using JSON and APEX and gave two examples were we use it.

In previous blog posts I gave more details on those techniques. Here's a quick overview:

Change first day of week in APEX 5.0 Calendar

APEX 5.0 comes with a new calendar region, which is way nicer than the previous calendar in APEX. It has more features, looks better and is also responsive. Behind the scenes you'll see the calendar region is based on Full Calendar.

In Belgium we use Monday as first day of the week, whereas in the US they seem to use Sunday as start of the week in the calendar overview. I've been integrating Full (more...)

APEX 5.0: There are issues with the configuration of the Static Files in your environment

After installing Oracle APEX 5.0, do you get the alert “There are issues with the configuration of the Static Files in your environment. Please consult the “Configuring Static File Support” section in the Application Express Installation Guide.” when you try … Continue reading

APEX 5.0 UI Training – Looking back and towards the future

This week Dimitri Gielis and I ran a training day about all the new APEX 5.0 UI features. We had a full room with 20 enthusiastic attendees from 4 different countries. We covered some general APEX 5 UI features, the Universal Theme, Responsive Grid layouts, Template Options, Theme Roller, Theme Styles and bringing it all together using some advanced features. See the website for more details.
And - as it was the first time (more...)

APEX 5 New Feature Kurs

Vom 01.06. bis zum 02.06. wird es in der nähe von Frankfurt den wohl ersten APEX 5 New Feature Kurs in Deutschland geben.

Wer Interesse an den APEX 5 Neuerungen hat und schon bald eine Migration plant, der sollte sich jetzt noch schnell anmelden.

Ps.: Ich selbst werde auch eine Session zu APEX 5 Migrationen halten.